Mail Merge Email containing multiple records in the body of one email per recipient.

How would I create a mail merge email that sends one email to each unique email address in a worksheet and includes the mail merge data for all of the records that have the same email address?  I have a worksheet that has a list of equipment that is assigned to each user.  I want to send an email to each user listing the equipment they have.
I can make it send an email for each item, but I want to consolidate the list by user and send one email to each.
Michael SpellmanSupervisory Operations Support SpecialistAsked:
Who is Participating?
Michael SpellmanSupervisory Operations Support SpecialistAuthor Commented:
Upon more trial & error, this method is not very user-friendly.  I opted to produce the emails with the listed items in Access.  It is more flexible and  the email is much easier to create and maintain.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.