How do I use VBA to put all recipients in the same email if they come from the same company?

Question

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!

Answer 1

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:

http://bit.ly/1hduSCB

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.