Mail Merge Many URLs in one email by common email address

[instantaphex]

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:

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!