Is there a need to make XL do all that work? When I copy the cells, go to
Outlook, and hit paste, it handles them just fine.

--
Best Regards,

Luke M
"Howard" wrote in message
...
I am using Excel 2003
In each cell of a column I have a unique email address - several hundred
in total.
I want to send the same circular email (using Outlook 2003) to each
address in the column
Is it straightforward to convert the list into a single string separated
by semicolons that can be cut and pasted into the BCC field of an email?
Is there a better way?
Thanks all
Howard