ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I send a xl-sheet as a mail using a VBA-script? (https://www.excelbanter.com/excel-programming/347097-how-do-i-send-xl-sheet-mail-using-vba-script.html)

SOJ

How do I send a xl-sheet as a mail using a VBA-script?
 
I'm trying to create a macro that sends the active excel-sheet to
mail-recipients.
I use "record a macro" and perform all the steps and even sends the mail.
When I stop recording the script is empty.

Norman Jones

How do I send a xl-sheet as a mail using a VBA-script?
 
Hi SOJ,

See Ron de Bruin's SendMail page for samole code:

http://www.rondebruin.nl/sendmail.htm

---
Regards,
Norman



"SOJ" wrote in message
...
I'm trying to create a macro that sends the active excel-sheet to
mail-recipients.
I use "record a macro" and perform all the steps and even sends the mail.
When I stop recording the script is empty.





All times are GMT +1. The time now is 11:55 PM.

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