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

W

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 = "[email protected]" or ".ReplyTo = "[email protected]". Any
suggestions on how to set this up.
 
K

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