07 only allows for the entire
workbook to be sent to a mail reciepient.

Not True

You can add this option to the QAT if you want
Read how on this page
http://www.rondebruin.nl/0307commands.htm


The name is "Send to Mail Recipient"
Search for it in the commands that are not in the ribbon list




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Kim K" wrote in message ...
Thank you for your reply, yes you are correct this is an option in Office
2003, but not in 2007, which is my problem. 07 only allows for the entire
workbook to be sent to a mail reciepient.
--
Thanks,,
Kim


"challa prabhu" wrote:

Hi,

Send a workbook or worksheet as a message in e-mail


1. Open the workbook you want to send.
2. If you want to send specific cells on a worksheet, select the cells you
want to send.

A. On the File menu, point to Send To, and then click Mail Recipient.

B. If prompted whether to send the entire workbook or just the current
sheet, click Send the current sheet as the message body.

3. In the To and Cc boxes, enter recipient names, separated by semicolons.
4. If you want to verify names you've typed against your address book, click
Check Names .
5. Type a subject in the Subject box.
6. If you are sending Microsoft Excel data as a message, you can include
explanatory text. Type your text in the Introduction box.
7. If Microsoft Outlook is your mail program, you can customize the message.

Challa Prabhu

"Kim K" wrote:

There has got to be an easy way for my staff to send one sheet of a workbook
via email. I have read thru pages of web sites but not found anything easy
to use or do.

Any suggestions for my staff welcome!
--
Thanks,,
Kim