exporting a column of data in excel to comma separated list in Word

[momma_hav]

I am using Office 2003 with Win 7. I have a list for approximately 40,000 emails and other data in Excel. I need to have the emails exported from the Excel column to a list in Word separated by commas, basically so that they can be put into emails to send out information in group emails to customers. I have saved a portion in an Excel format, a CSV format. Then I have opened the CSV format in Word but it gives me the emails in list. Now I can add the "comma, space, delete" and bring everything into more or less one paragraph looking group but not for 40K. Is there a way I can do this either by exporting from Excel or opening in Word? I have attached Test files in Excel, CSV and Word.
Thanx in advance.

[ChemistB]

In Excel, go to sheet 2 and in A1 use this formula

=INDEX(Test1!$A$1:$A$4000, (ROW(A1)-1)*256 +(COLUMN(A1)))
Copy that all the way across (shortcut, CNTRL SHFT Right Arrow and then CNTRL + R)
and down (and also across) as far as you need it. (modify the range if you are going over A4000 in sheet1.)

Now save sheet2 as a CSV and open it in Word
To remove paragraph breaks every 256 entries, then CNTRL H > search for ^p and replace with ,
Did that work for you?