I have a worksheet that is 5 columns wide. The 1st column is email, 2nd
column is name, 3rd and 4th is address and 5th is city/st/zip.
Is there a way to autosend an email 1 row at a time. It would pull the
email address from column 1, insert a predetermined subject that would be
consistent with all of the emails, and then in the message insert another
brief statement followed by inserting columns 3,4,5?
I hope this is not to confusing.

Thanks in advance for any help you may be able to offer.
Steve

Hi Steve

See my site for example code
http://www.rondebruin.nl/sendmail.htm

Maybe this one
http://www.rondebruin.nl/mail/folder3/message.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steve" wrote in message ...
I have a worksheet that is 5 columns wide. The 1st column is email, 2nd
column is name, 3rd and 4th is address and 5th is city/st/zip.
Is there a way to autosend an email 1 row at a time. It would pull the
email address from column 1, insert a predetermined subject that would be
consistent with all of the emails, and then in the message insert another
brief statement followed by inserting columns 3,4,5?
I hope this is not to confusing.

Thanks in advance for any help you may be able to offer.
Steve