ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Email selected worksheets from a workbook as attachment. (https://www.excelbanter.com/excel-worksheet-functions/90968-email-selected-worksheets-workbook-attachment.html)

osoloco

Email selected worksheets from a workbook as attachment.
 
I need to find a way to email selected worksheets from a workbook as
attachments.
I've found a sharware program called PATools but I'd like a better way if it
exists.
Thanks for any help.

Norman Jones

Email selected worksheets from a workbook as attachment.
 
Hi Osloco,

I need to find a way to email selected worksheets from a workbook
as attachments.
I've found a sharware program called PATools but I'd like a better
way if it exists.


Ron de Bruin has sample code at:

http://www.rondebruin.nl/mail/folder2/mail3.htm

See also Ron's main Email page at:

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

If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


---
Regards,
Norman




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

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