ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to Email single worksheet? (https://www.excelbanter.com/excel-programming/343620-how-email-single-worksheet.html)

Bill James[_2_]

How to Email single worksheet?
 
Would like to email a single worksheet as attachment or body of message.
Not to whole workbook. I've played with the Send To options but can't seem
to record the VBA code.



Norman Jones

How to Email single worksheet?
 
Hi Bill,

See Ron de Bruin's SendMail pages for sample code:

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


---
Regards,
Norman



"Bill James" wrote in message
...
Would like to email a single worksheet as attachment or body of message.
Not to whole workbook. I've played with the Send To options but can't
seem to record the VBA code.




David Adamson[_4_]

How to Email single worksheet?
 
Bill,

Check out Ron de Bruin's page on this topic at

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




"Bill James" wrote in message
...
Would like to email a single worksheet as attachment or body of message.
Not to whole workbook. I've played with the Send To options but can't
seem to record the VBA code.




Bill James[_2_]

How to Email single worksheet?
 
Thanks you both... good link.

"Bill James" wrote in message
...
Would like to email a single worksheet as attachment or body of message.
Not to whole workbook. I've played with the Send To options but can't
seem to record the VBA code.





All times are GMT +1. The time now is 08:35 AM.

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