Mail Merge Multiple Data to One Email ID
Hi all
For example, I have the details in an excel sheet as seen below -
Unique ID - Comment - Email ID
A - Hello - email1@email.com
A - Hi - email1@email.com
B - What - email2@email.com
B - Hiya - email2@email.com
When we use normal mail merge with excel, from the details above - FOUR emails will be sent, TWO to email1@email.com and TWO to email2@email.com.
What I want to send to the email recipient ( say, to : email1@email.com ) is as below, in ONE single mail -
A - Hello
A - Hi
Please let me know how to carry out the process.
TIA