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

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.

"Higesan" wrote:

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

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.


--
-Brigette


"trip_to_tokyo" wrote:

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.

"Higesan" wrote:

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

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



--

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


"Higesan" wrote in message ...
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