Excel mail merge consolidating multiple rows with a like identifier

[sgoeagles94]

Hello, I am trying to do a mail merge from excel, where multiple rows could be on the same email. The like identifier can be either the Store # or the email address. I have successfully set this up, however, each line is receiving an email, and I want to consolidate if the store # is the same, to receive just one email.

Here is what I need my email to say for example:
Dear Customer:
Thank you for your order. You have ordered the following:

Order # Store # Style Size Description Units
93456727 11684 MC277 XL-R Unisex Crew Jogger 50
99345672 11684 MC366 S-R Tricot Polo 2

This 1 email should be going to email1@gmail.com. The way I have it now, email1@gmail.com is receiving 4 separate emails.

I have added a compare column (not sure if I need this or not?) which could either be the Store # or email address, they will be emailing the same person. I am really struggling to get this to work. If anyone can help, I would so appreciate it!!

Store	Order	Style	Size	Description	Units	Email	Compare
11684​	93456727​	MC277	'XL-R'	UNISEX CRW JOGGER	50​	email1@gmail.com	11684​
11684​	99345672​	MC366	S-R'	TRICOT POLO	2​	email1@gmail.com	11684​
23584​	93358587​	MC110	'L-L'	M MGR NVY TALL LS SHIRT	4​	email1@gmail.com	23584​
24270​	93303857​	MC277	'M-R'	UNISEX CRW JOGGER	2​	email1@gmail.com	24270​
990390​	93174040​	MC277	'XS-R'	UNISEX CRW JOGGER	8​	email2@gmail.com	990390​
990390​	93311264​	MC277	'M-R'	UNISEX CRW JOGGER	6​	email2@gmail.com	990390​
990390​	93324922​	MC366	'M-R'	TRICOT POLO	4​	email2@gmail.com	990390​
990390​	93526725​	MC110	'S-R'	M MGR WHITE SHIRT	4​	email2@gmail.com	990390​

 

[loebjs]

Hello, I am trying to do a mail merge from excel, where multiple rows could be on the same email. The like identifier can be either the Store # or the email address. I have successfully set this up, however, each line is receiving an email, and I want to consolidate if the store # is the same, to receive just one email.

Here is what I need my email to say for example:
Dear Customer:
Thank you for your order. You have ordered the following:

Order # Store # Style Size Description Units
93456727 11684 MC277 XL-R Unisex Crew Jogger 50
99345672 11684 MC366 S-R Tricot Polo 2

This 1 email should be going to email1@gmail.com. The way I have it now, email1@gmail.com is receiving 4 separate emails.

I have added a compare column (not sure if I need this or not?) which could either be the Store # or email address, they will be emailing the same person. I am really struggling to get this to work. If anyone can help, I would so appreciate it!!

Store	Order	Style	Size	Description	Units	Email	Compare
11684​	93456727​	MC277	'XL-R'	UNISEX CRW JOGGER	50​	email1@gmail.com	11684​
11684​	99345672​	MC366	S-R'	TRICOT POLO	2​	email1@gmail.com	11684​
23584​	93358587​	MC110	'L-L'	M MGR NVY TALL LS SHIRT	4​	email1@gmail.com	23584​
24270​	93303857​	MC277	'M-R'	UNISEX CRW JOGGER	2​	email1@gmail.com	24270​
990390​	93174040​	MC277	'XS-R'	UNISEX CRW JOGGER	8​	email2@gmail.com	990390​
990390​	93311264​	MC277	'M-R'	UNISEX CRW JOGGER	6​	email2@gmail.com	990390​
990390​	93324922​	MC366	'M-R'	TRICOT POLO	4​	email2@gmail.com	990390​
990390​	93526725​	MC110	'S-R'	M MGR WHITE SHIRT	4​	email2@gmail.com	990390​

I have the same issue... did you ever get an answer?