How to email just one worksheet in a workbook?

[John L]

I have a workbook with many sheets. I want to send just one of the
worksheets to someone.
Do I have to create special workbook and copy the sheet I want to send to
it?
Thanks for your help.

 

[Peo Sjoblom]

You'd need VBA if you don't want to make a one sheet workbook

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

 

[John L]

Thanks. I suspected as much. As powerful as Excel is, it seems strange that
this capability isn't built in.
For my application and infrequent use at present. I'll just make the one
sheet workbook and copy the desired sheet to it.
John

 

[Rob]

Hi John,

I'm using Office XP, Word as mail editor, Outlook XP as my mail
client.

1) Open workbook.
2) Select sheet tab for sheet you would like to e-mail.
3) Press "e-mail" button, or select File->Sent TO->Mail Recipient.
4) Enter destination address, subject, intro, etc.
5) Click somewhere in worksheet (any cell will do) to make worksheet
active/target. You'll notice the "Send this selection" button will
change to "Send this sheet button".
6) Click "Send this sheet" or "Send now" to send the target worksheet.
a) You should have the option of selecting different worksheet by
clicking on the different worksheet tabs, etc.
b) You can also send a specific selection/range by highlighting the
range and pressing "Send this selection".

Note: This will send the worksheet in the body of the message.

Regards,

V

 

[Dave Peterson]

Or just rightclick on the sheet to send, choose "move or copy" and copy it to a
new workbook (in the top box in that dialog). Then send that new workbook.

Close it without saving (if you did a Copy--not Move!).