ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how can i insert an e-mail address to a worksheet using VBA (https://www.excelbanter.com/excel-programming/324352-how-can-i-insert-e-mail-address-worksheet-using-vba.html)

AidanJ

how can i insert an e-mail address to a worksheet using VBA
 
I would like to send single worksheets as HTML mails to various single mail
recipients, getting their SMTP address from a table in the workbook. Can
this be done using VBA?

Bob Phillips[_6_]

how can i insert an e-mail address to a worksheet using VBA
 
Take a look at www.rondebruin.nl/sendmail.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"AidanJ" wrote in message
...
I would like to send single worksheets as HTML mails to various single

mail
recipients, getting their SMTP address from a table in the workbook. Can
this be done using VBA?





All times are GMT +1. The time now is 04:55 AM.

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