ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to email excel 2007 worksheet with outlook 2007 (https://www.excelbanter.com/excel-worksheet-functions/170619-how-email-excel-2007-worksheet-outlook-2007-a.html)

djog6944

how to email excel 2007 worksheet with outlook 2007
 
I can send the workbook but not an individual sheet. Any ideas out there?

Ron de Bruin

how to email excel 2007 worksheet with outlook 2007
 
Hi ?

For code or a Add-in see
http://www.rondebruin.nl/sendmail.htm

Manual:
Right click on the tab and choose Move or copy
Check the create a copy check box
In the To book dropdown choose New Book

Now you have a new workbook with one sheet that you can send



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"djog6944" wrote in message ...
I can send the workbook but not an individual sheet. Any ideas out there?



All times are GMT +1. The time now is 10:25 PM.

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