How to send as email body only the selected page of a worksheet

M

MDWNSJ

I have a sheet in my workbook that needs to have information on pages beside
each other to enable me to view them in this format. Only one of these pages
is to be emailed to the client and the other remains confidential. I want to
include as the body of an email only the page selected so that the client can
respond to the form and return it to me by simply replying. Can someone tell
me how to do this?
 
S

Stan Brown

Fri, 1 Feb 2008 22:17:01 -0800 from MDWNSJ
I have a sheet in my workbook that needs to have information on pages beside
each other to enable me to view them in this format. Only one of these pages
is to be emailed to the client and the other remains confidential. I want to
include as the body of an email only the page selected so that the client can
respond to the form and return it to me by simply replying. Can someone tell
me how to do this?
Click to expand...

Google is your friend. I entered this search
"email one worksheet from a workbook"
(with quotes).
 
M

MartinW

Hi,

You could just have a seperate workbook for emailing.
Copy and paste the clients section to the new workbook
and email that book. When you get it back from your
client just copy and paste the info back into your master.

HTH
Martin
 
G

Gord Dibben

You can send a worksheet as body of an email but you cannot send a portion of a
a worksheet.

Copy that portion and paste into an email directly or copy that potion to a new
worksheet and File>Send to Mail Recipient>Send Current sheet as body.


Gord Dibben MS Excel MVP
 
M

Mc/

Select the desired cells from the worksheet
Create a new email and simply paste into the email message area.

However, I sense that what you are attempting is to email the complete
worksheet without including all other worksheets in the workbook.

To do this I would select the desired worksheet Tab, rt. Click on the tab,
Select Move or Copy.
Check the make a Copy at the lower left of the dialog window.
on the TO: Book, drop down and choose New Book.
This will clone the selected Worksheet to a new workbook and transfer you to
that new workbook.
From there, Select FILE; Send To; As attachment.
Complete the eMail addressing and Send.
You will be returned to the 'New Workbook', where you can exit without
saving, since you do not need it to be saved.
 
K

Kelly

If you are using Excel 2007:
In your quick access toolbar, select "More Commands"
In the Choose commands field select "All Commands"
Select "Send to Mail recipient" and add it to your quick access toolbar.

When you use this icon, select send the current sheet as the message body.

Hope this helps.
 
Top