Recent content by TomBurton

  1. T

    SentOnBehalfOfName issue when using excel to create an outlook email

    Hi Gasman, Been busy so hadn't managed to get round to looking at this in a while. I ran the code (I think correctly) and it returned 1 account. This may be why I can't access the 2nd account (shared account) email. I can send from the shared email when I have an email open and can manually...
  2. T

    SentOnBehalfOfName issue when using excel to create an outlook email

    Sorry to be a pain. I don't know what you mean. I see your code that you posted but I'm unsure what I'm doing with it. Can you talk me through what I need to do as if I had no clue of VBA? Thanks for your help.
  3. T

    SentOnBehalfOfName issue when using excel to create an outlook email

    There is a different account, a shared one which our IT department gives access to required staff. We can manually select the email we want to send from once the email has opened but I want to automate that step as it should always come from the shared email account when sending this email. Can...
  4. T

    SentOnBehalfOfName issue when using excel to create an outlook email

    Hi Gasman, I'm unsure of what you mean. Each user has their own account but the email wants sending using a shared email.
  5. T

    SentOnBehalfOfName issue when using excel to create an outlook email

    I am a self taught vba user with not a high level. Most of my code is used by finding related code and editing it for my own use. I have been using some vba code which uses SentOnBehalfOfName. One day it randomly stopped working. When the macro is run, it loads the email and then outlook closes...
Back
Top Bottom