Combing multiple records to one email
Hey guys,
I've attached a sample chart that I'm trying to use mail merge to email out to my employees. While, I can use the mail merge function, the issue I'm having is since I have multiple records for the same person, they are receiving multiple emails.
Is there a way I can combine records based on a specific field and send all of those to one email?
Attached is an example excel file I'll be using to send the mail merge and a word document as an example of the email that John Doe would receive based on the mail merge.
Thanks for the help!
|