ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can you email a single worksheet in a workbook in Excel 2007? (https://www.excelbanter.com/excel-worksheet-functions/160709-can-you-email-single-worksheet-workbook-excel-2007-a.html)

RLB

Can you email a single worksheet in a workbook in Excel 2007?
 
Can you email a single worksheet in a workbook in Excel 2007? If so, what
are the step-by-step directions? Is code invovled?

Ron de Bruin

Can you email a single worksheet in a workbook in Excel 2007?
 
Hi RLB

You can do it manual but maybe my add-in is a good option

For code and the add-in see
http://www.rondebruin.nl/sendmail.htm

Manual:
Right click on the sheet tab and choose "Move or Copy"
Check the "Create a copy" check box and choose new workbook in the "To Book" dropdown

Now you have a new workbook and can use the normal way to send the workbook


--

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


"RLB" wrote in message ...
Can you email a single worksheet in a workbook in Excel 2007? If so, what
are the step-by-step directions? Is code invovled?


RLB

Can you email a single worksheet in a workbook in Excel 2007?
 
Perfect. Thank you

"Ron de Bruin" wrote:

Hi RLB

You can do it manual but maybe my add-in is a good option

For code and the add-in see
http://www.rondebruin.nl/sendmail.htm

Manual:
Right click on the sheet tab and choose "Move or Copy"
Check the "Create a copy" check box and choose new workbook in the "To Book" dropdown

Now you have a new workbook and can use the normal way to send the workbook


--

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


"RLB" wrote in message ...
Can you email a single worksheet in a workbook in Excel 2007? If so, what
are the step-by-step directions? Is code invovled?




All times are GMT +1. The time now is 12:41 PM.

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