Thread: Reply to different address
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Reply to different address
Hi Shaun

With Outlook code and CDO it is possible

See my pages with Outlook object model examples
http://www.rondebruin.nl/sendmail.htm

If you want to change the sender name and reply address add this code line

'The receiver can see the original mail address in the properties if he want
..SentOnBehalfOfName = """SenderName"" "




Or see the CDO page



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Shaun" wrote in message ...
Is it possible to reply to a different address using the mailevelope function
in Excel?

Thanks in Advance!
--
~Shaun


Reply With QuoteReply With Quote