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...
Top Bottom