Email a single Excel worksheet instead of the whole workbook.

[Elgin]

I have an Excel workbook with several worksheets. I want to email just one of
these worksheets to a friend. It would be great to be able to right-click the
worksheet tab and find the option to send worksheet as an attachment.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...a-f0f6eb525302&dg=microsoft.public.excel.misc

 

[marysully]

An easy way is to select and copy the worksheet you want to email, then
create a new workbok (excel file) and paste the worksheet in. Have done it in
the past and works fine.

 

[Gord Dibben]

All you ever need to know about emailing from Excel can be found at Ron de
Bruin's site.

http://www.rondebruin.nl/sendmail.htm

Note the free Sendmail Add-in to make your life easier.


Gord Dibben MS Excel MVP