VBA TO USE "Reply To" or "From" to send email from excel

[wollywoo]

Hi,

I am needing to create a code that will allow me to send email to
receipients without them being able to reply to me as a contact. I would
like to have them reply to a generic mailbox. I keep getting errors when I
use".From = "(e-mail address removed)" or ".ReplyTo = "(e-mail address removed)". Any
suggestions on how to set this up.

 

[Ken Slovak - [MVP - Outlook]]

You'd get errors because those properties don't exist, so it would be a
problem setting them.

You can set the SentOnBehalfOfName property and you can get the
ReplyRecipients collection of the mail item and add a recipient to that
collection based on the reply address you want used.