Hello - I'm trying to find a way to set up a mail merge for multiple lines of data. I want only ONE email sent out to each recipient but in that email it would list out multiple lines of data. I don't really care how it formats - could be a table, bulleted list, etc. Here is how my excel sheet is set up. My data in excel is set up in column A to list the recipients email and in column B the data I want to send to them in one email. The data sheet will list their email for every policy they own but I want to avoid sending multiple emails (one for each policy) but rather it send ONE email with a list of all the policies they own. Example below.
Email Policy
Laura@abc.com Policy A
Laura@abc.com Policy B
Laura@abc.com Policy C
Laura@abc.com Policy D
Michael@abc.com Policy Z
michael@abc.com Policy Y
I'd like to send an automated email to all recipients using mail merge that would look something like this...
Hi Laura or [Recipient]
Below is a list of all of the Policies we have on file that you own. Please verify.
Policy A
Policy B
Policy C
Policy D
Thank you,
Bob
Bookmarks