ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Mass Email (https://www.excelbanter.com/excel-programming/340177-mass-email.html)

Steve[_71_]

Mass Email
 
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


Ron de Bruin

Mass Email
 
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





All times are GMT +1. The time now is 09:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com