I'm working with Excel 2008 for mac and I've got a large spreadsheet with thousands of rows. The project I am working on is a back link pruning project for SEO purposes. The data I am working with is organized like this:

|____________URL______________|______EMAIL______|
|http://www.example.com/1 |[email protected] |
|http://www.example.com/2 |[email protected] |
|http://www.example.com/3 |[email protected] |
|http://www.example.com/4 |[email protected] |
|http://www.example.com/5 |[email protected] |
|http://www.example.com/6 |[email protected] |
|http://www.example.com/7 |[email protected] |
|http://www.example.com/8 |[email protected] |
|http://www.example.com/9 |[email protected] |

The URL column contains a URL to a page that contains a back link to the website in question. I would like to do a mail merge and send each email address 1 email with a list of the links to my site instead of 50 emails each containing one link. What I would like for the data to look like is this:

|____________URL______________|______EMAIL______|
|http://www.example.com/1 |[email protected] |
|http://www.example.com/2 | |
|http://www.example.com/3 | |
|http://www.example.com/4 | |
|http://www.example.com/5 | |
|http://www.example.com/6 | |
|http://www.example.com/7 | |
|http://www.example.com/8 | |
|http://www.example.com/9 | |

Where the URLs are all concatenated into a single row with only a single email address. This way, when I do the mail merge, the entire list of links will be inserted into the email as a single cell. Is this possible? If not, is there another way I can go about this using Excel 2008 for mac and Microsoft Entourage?

Thanks!