I would like to send one email directed to multiple people. Also, if the recipients are from the same company, they should be in the same email thread.
For example:
**To: jenna@abcompany.com, mark@abcompany.com
From: Me
Dear Jenna and Mark,
XXXX
Best regards,
Me**
Is there any way I could use VBA to:
(a) put two first names in the email body and
(b) put all recipients in the same email if they come from the same company.
Thank you!
If you have all of the data in an Excel Workbook, you could use a macro to arrange the data as required so that it could be used as a data source for a mail merge that would sent the messages using the Merge with Attachments facility on my Merge Tools Add-in that is contained in the MERGE TOOLS ADD-IN.zip file that you can download from the following page of my One Drive:
Extract the files from the archive and read the:
“READ ME – Setting up and using the Merge Tools Add-in.pdf
to see how to install and use the various tools.
If you send me a copy of the data that you have, using the email address in the Read Me First.jpg at the above website, I will help you to get it set up.
2 people are following this question.
