Combing multiple records to one email

srheajr · #1 07-19-2017, 10:37 PM

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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple Records Mail Merge using Email	Skybluekid	Mail Merge	1	03-28-2016 02:33 PM
Multiple records per document	peterkp	Mail Merge	16	06-26-2014 06:03 PM
Multiple records on the same page	Hugh	Mail Merge	2	04-04-2014 05:24 PM
How can I retreive multiple records using a lookup?	jrpey	Excel	3	11-14-2011 02:10 PM
Help with consolidating multiple records into one	wbiggs2	Excel	0	11-30-2006 01:02 PM