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
2022-04-11T06:08:41.717+00:00

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!

0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Doug Robbins - MVP - Office Apps and Services 166 Reputation points MVP
    2022-04-13T10:45:01.55+00:00

    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.

    0 comments No comments