Thread: Emailing Activesheet As Body of Email
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming, microsoft.public.outlook,microsoft.public.outlook.program_vba
PWS PWS is offline
external usenet poster
  
Posts: 18
Default Emailing Activesheet As Body of Email
On Dec 16, 3:48 pm, "Sue Mosher [MVP-Outlook]"
wrote:

Yes, as I said, you need to return ActiveSheet.MailEnvelope.Item, which is a MailItem, and
then work with its ReplyRecipients collection, just as you would its Recipients. Use the Add method.

Thanks Sue, I have the code functioning as I require, treating
ActiveSheet.MailEnvelope.Item as a MailItem allowed me to set both the
ReplyTo and SentOnBehalfOf properties.

Thanks again.

PWS
Reply With QuoteReply With Quote