Does anyone know of a way to group different rows of data in Excel into emails to specific recipients based upon the rows wich have their name in a recipient column?
I can do a mail merge with my Excel spreadsheet where it sends an email to each person in the recipient column. However, my issue is that the recipients get a separate email for each row of information that has their name in the recipient column. I would like for it to group all of the recipients' rows of data into one email for each of them. Does this make sense? Has anyone dealt with this before and do you have any suggestions?
Thank you for any help you can provide!!
I can do a mail merge with my Excel spreadsheet where it sends an email to each person in the recipient column. However, my issue is that the recipients get a separate email for each row of information that has their name in the recipient column. I would like for it to group all of the recipients' rows of data into one email for each of them. Does this make sense? Has anyone dealt with this before and do you have any suggestions?
Thank you for any help you can provide!!
