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

  • Thread starter Thread starter wollywoo
  • Start date Start date
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 = "(e-mail address removed)" or ".ReplyTo = "(e-mail address removed)". Any
suggestions on how to set this up.
 
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.
 
Back
Top