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?