Mail Merge Many URLs in one email by common email address

instantaphex · #1 04-25-2013, 12:15 PM

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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge won't email	QEDDave	Mail Merge	11	10-29-2014 09:44 PM
Mail Merge to email, changing images on email layout	ginelli	Mail Merge	18	02-23-2013 09:47 AM
Outlook won't reply/forward email from one email address	rluna68	Outlook	2	01-07-2013 12:42 PM
Convert mail merge to PDF then email	TeriJean	Mail Merge	0	10-04-2011 03:52 PM
Mail Merge via Proxy Email?	ghillie30	Mail Merge	0	07-08-2011 06:26 AM