Forum Discussion
Add recipients and email workbook in a macro
shetzel In your code there is this line:
Application.Dialogs(xlDialogSendMail).ShowWhat is not widely known is that the Show method accepts arguments. The first argument is the "To" email address. So if you change that code to this:
Application.Dialogs(xlDialogSendMail).Show "email address removed for privacy reasons"the To address wil be prefilled with "email address removed for privacy reasons. ". In addition, the second argument is the subject line.
shetzel In your code there is this line:
Application.Dialogs(xlDialogSendMail).Show
What is not widely known is that the Show method accepts arguments. The first argument is the "To" email address. So if you change that code to this:
Application.Dialogs(xlDialogSendMail).Show "email address removed for privacy reasons"
the To address wil be prefilled with "email address removed for privacy reasons. ". In addition, the second argument is the subject line.
I entred the line you provided and it works for the first email recipient, but how do I get it to go to multiple recipients?
Thanks
- If you want multiple addresses, use this instead of "address1":
array("address1","address2","address3")- Thank you