See Ron de Bruin's site for code to send an email to every valid email
address in a range.

http://www.rondebruin.nl/mail/folder3/message.htm

No need to put all the addresses in one cell.


Gord Dibben MS Excel MVP

On Wed, 11 Mar 2009 14:47:01 -0700, spenlc
wrote:

I am attempting to take a spreadshhet of email address a1-a1350 and make them
one string of addresses in the same cell to send out a mass email. Is there a
formula that I can enter to do this all at once or am I going to have to do
them one at a time