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

JP_SH 1 Reputation point

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:

From: Me

Dear Jenna and Mark,


Best regards,


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!

0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Doug Robbins - MVP - Office Apps and Services 166 Reputation points MVP

    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 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.

    0 comments No comments