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?

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?

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

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

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


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

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 FileSend to Mail RecipientSend Current sheet as body.


Gord Dibben MS Excel MVP

On Fri, 1 Feb 2008 22:17:01 -0800, MDWNSJ
wrote:

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?

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.

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.


"MDWNSJ" wrote:

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?