Excel, Outlook, Word - Mail Merge With Unique Subject Lines

[funkylad20]

Hello all, I have a very challenging and specific question!

I have a list of unique numbers (900 of them, called 'URNs'), which are in a spreadsheet in one column.

I need to send an identical email somewhere with 10 of these numbers in the subject line (so obviously 90 emails).

Is there any way using Excel, Word (mail merge?) or Outlook that will make this process simple, quick and work?

The subject line needs to look somethhing like the below:

'[URN,URN,URN,URN,URN,URN,URN,URN,URN,URN] Subject Line Text' x 91 emails like this, with the same attachements etc.

The quickest solution I can see so far is to 'transpose' the numbers so they are on a row in Excel and copy and past 10 at a time into table in Word and 'Convert (the table) to text' with a comma separator, then copy and past 90 times into 90 emails!

An alternative was to use Word Mail Merge from Excel to create the same thing (with some manual editing like adding in commas, the square brackets and the subject line, 90 times) and again copy and past the subject line (from Word) into 90 separate emails.

Obviously these two options are quite fiddly and time consuming, so any suggestions would be most helpful! Incidentally, I have MS Office 2010 (Word, Excel and Outlook).

Thanks!