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

[RLB]

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]

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

 

[RLB]

Perfect. Thank you

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