Solved VBA Sending Email - Hardcode From field

[drifter96]

Hello,

Is there a way to hardcode the From field when sending an email through VBA to Outlook? We are trying to have the Department name show up instead of the person sending the email.

TIA

 

[pbaldy]

If you're using Outlook automation, this type of thing:

MyMail.SentOnBehalfOfName = "AR@OurCompanyName.com"

 

[drifter96]

Thank you!

 

[pbaldy]

Happy to help! Note you may need to add delegate permissions for the account being used.