Hi Ruth,
You may have trouble mailing 300 all at once from most home user ISP
accounts. You may also have trouble with one very large concatenation
due to limits in Excel.

But you can use simply end each name with a comma or semicolon
=Trim(a1)&","

and copy down then copy and paste your B column into the To or BCC area.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ruthe6" wrote in message ...
I have an electronic newsletter that I send out once/month that I export the
addresses to an Excel worksheet. I need to be able to combine all address
(over 300) with a comma between to copy and paste to the newsletter.

Help!