Email single worksheets

[Higesan]

How do you email a single worksheet out of a workbook with multiple sheets. I
have not been able to figure this out. I am looking for an easy way rather
than attempting to cut and paste

 

[trip_to_tokyo]

This is the way that I do it:-

1. Create a copy of the Workbook (maybe give it a different name).

2. Go into the copy that you have created and delete all the sheets except
the one that you want to send.

3. Save the file and then send it with just the single worksheet that you
wish to send.

If my comments have helped please hit Yes.

 

[Brigette]

To avoid having to delete the extra sheets, another method is:
1. Right click on the tab of the sheet you want to send
2. Select "Move or Copy"
3. Under "To Book" select "(new book)"
4. Put a check mark in "Create a copy"
5. Click OK

Now that one sheet will automatically open in a new workbook. Just save it
and send it.

 

[Ron de Bruin]

You can use also use code
http://www.rondebruin.nl/sendmail.htm

Or install a add-in to do it(very easy)
http://www.rondebruin.nl/mail/add-in.htm