I have a spreadsheet of many URLs in one column and a list of email addresses in an adjacent column. I've been googling and reading tutorials and I haven't been able to figure out what it is that I'm trying to do.
What I would like to do is mail merge to my inbox a single email per email address which contains all of the URLs associated with the email address.
For example, consider the following spreadsheet:
Code:
URL email
http://www.example.com/1 owner@example.com
http://www.example.com/2 owner@example.com
http://www.example.com/3 owner@example.com
http://www.otherexample.com/1 owner@otherexample.com
http://www.otherexample.com/2 owner@otherexample.com
I would like to send a single email to
owner@example.com with the following info:
http://www.example.com/1
http://www.example.com/2
http://www.example.com/3
as well as an email to
owner@otherexample.com with the following:
http://www.otherexample.com/1
http://www.otherexample.com/2
I'm having the hardest time understanding the syntax of mail merge logic statements. Can anyone help me out with this?
Thanks!