I have an Excel spreadsheet with a list of employees with email addresses that have item(s) available for reimbursement. Some have one item others have as many as seven.
I want to create a personalized email for each associate and their personal respective items for reimbursement. I also want to merge the data to the email from the spreadsheet.
How do I merge to email and ONLY put the respective reimbursable items in each email?
e.g.
EMAIL #1
-John Doe
--Item 1
--Item 2
--Item 3
EMAIL #2
-Jane Doe
--Item 1
EMAIL #3
-James Doe
--Item 1
--Item 2