You don't email a sheet per se, you email what basically is a pasted copy of
the sheet, you can't email any formulas like if you would email the workbook
so in a way yes you can email a copy of the sheet for viewing but nothing to
put your teeth into

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Sandy" wrote in message
...
Peo...I was just at the computer that has Office 2003...when you click on
the
letter/envelope on the tool bar you get the following
message...Email...you
can send the entire workbook as an attachment to an email message or send
the
current sheet as the body of an email message..the you get 2 choices...1st
choice is send the entire workbook as an attachment ..2nd choice is send
the
current sheet as the message body...I selected the message body and it
works...why not with office 2000 and Exchange 2003.

--
Stellier


"Peo Sjoblom" wrote:

How? Unless you have an add-in which would go under "Otherwise you would
need VBA."
it is not possible



Peo


"Sandy" wrote in message
...
Peo...thanks for getting back to me...I disagree with you...you
can/could
email a single worksheet in a workbook...we have done it with Excel
2003
and
we could do it before with outlook....

--
Stellier


"Peo Sjoblom" wrote:

You can't email a single sheet, never could. The only way manually is
to
copy the particular sheet to a new workbook and mail that workbook.
Otherwsie you would need VBA.


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Sandy" wrote in message
...
We are having a problem trying to email a single worksheet since we
have
installed Exhcange 2003. We are running Office 2000. We can email
the
whole
workbook but not just a sheet. We get a microsoft excel error
message
that
says Excel could not start the e-mail program. Check your network
connection.
Make sure Office is installed correctly, your email program is setup
correctly and you can connect to your email server. We have done all
of
this.
I thinkg that it might be the Office 2000 and Exchange 2003.
Thanks
--
Stellier