Excel VBA populate message etc of Email Envelope

Hi

I use the following code to open up the Excel Outlook envelope

Application.ActiveWorkbook.EnvelopeVisible = True

What further code would I use to populate the "To", "Subject" and message?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Rgonzo1971Commented:
HI,

pls try

ActiveWorkbook.EnvelopeVisible = True
      With ActiveSheet.MailEnvelope
      .Item.To = "aa@abc.com" & "; bb92@abc.org"
      .Item.Subject = "mySubject"
      .Item.Send
   End With

Open in new window

Regards
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Great. Answer. Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.