View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Howard Howard is offline
external usenet poster
 
Posts: 7
Default Creating emailing list from column of addresses

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