software

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

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

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

--
Stellierquot;Peo Sjoblomquot; wrote:

gt; You can't email a single sheet, never could. The only way manually is to
gt; copy the particular sheet to a new workbook and mail that workbook.
gt; Otherwsie you would need VBA.
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;Sandyquot; gt; wrote in message
gt; ...
gt; gt; We are having a problem trying to email a single worksheet since we have
gt; gt; installed Exhcange 2003. We are running Office 2000. We can email the
gt; gt; whole
gt; gt; workbook but not just a sheet. We get a microsoft excel error message that
gt; gt; says Excel could not start the e-mail program. Check your network
gt; gt; connection.
gt; gt; Make sure Office is installed correctly, your email program is setup
gt; gt; correctly and you can connect to your email server. We have done all of
gt; gt; this.
gt; gt; I thinkg that it might be the Office 2000 and Exchange 2003.
gt; gt; Thanks
gt; gt; --
gt; gt; Stellier
gt;
gt;
gt;

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.

--
Stellierquot;Peo Sjoblomquot; wrote:

gt; How? Unless you have an add-in which would go under quot;Otherwise you would
gt; need VBA.quot;
gt; it is not possible
gt;
gt;
gt;
gt; Peo
gt;
gt;
gt; quot;Sandyquot; gt; wrote in message
gt; ...
gt; gt; Peo...thanks for getting back to me...I disagree with you...you can/could
gt; gt; email a single worksheet in a workbook...we have done it with Excel 2003
gt; gt; and
gt; gt; we could do it before with outlook....
gt; gt;
gt; gt; --
gt; gt; Stellier
gt; gt;
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt;gt; You can't email a single sheet, never could. The only way manually is to
gt; gt;gt; copy the particular sheet to a new workbook and mail that workbook.
gt; gt;gt; Otherwsie you would need VBA.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt;
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; Peo Sjoblom
gt; gt;gt;
gt; gt;gt; nwexcelsolutions.com
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Sandyquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; We are having a problem trying to email a single worksheet since we
gt; gt;gt; gt; have
gt; gt;gt; gt; installed Exhcange 2003. We are running Office 2000. We can email the
gt; gt;gt; gt; whole
gt; gt;gt; gt; workbook but not just a sheet. We get a microsoft excel error message
gt; gt;gt; gt; that
gt; gt;gt; gt; says Excel could not start the e-mail program. Check your network
gt; gt;gt; gt; connection.
gt; gt;gt; gt; Make sure Office is installed correctly, your email program is setup
gt; gt;gt; gt; correctly and you can connect to your email server. We have done all of
gt; gt;gt; gt; this.
gt; gt;gt; gt; I thinkg that it might be the Office 2000 and Exchange 2003.
gt; gt;gt; gt; Thanks
gt; gt;gt; gt; --
gt; gt;gt; gt; Stellier
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Sandy

You can email selected range(s) from a worksheet as a quot;message bodyquot; but you
cannot send that sheet as an attached file on its own.

Semantics playing a part here, I do believe.Gord Dibben MS Excel MVP

On Thu, 27 Apr 2006 10:49:03 -0700, Sandy gt;
wrote:

gt;Peo...thanks for getting back to me...I disagree with you...you can/could
gt;email a single worksheet in a workbook...we have done it with Excel 2003 and
gt;we could do it before with outlook....
gt;
gt;--
gt;Stellier
gt;
gt;
gt;quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; You can't email a single sheet, never could. The only way manually is to
gt;gt; copy the particular sheet to a new workbook and mail that workbook.
gt;gt; Otherwsie you would need VBA.
gt;gt;Gord
I didn't select a range I just was on a particular sheet and did the
email...mind you the receipent sees this huge page...but you don't have to
select a range...I guess the answer to my question is if you are on the
Exchange 2003 for email you should be on Office 2003 also.
--
Stellierquot;Gord Dibbenquot; wrote:

gt; Sandy
gt;
gt; You can email selected range(s) from a worksheet as a quot;message bodyquot; but you
gt; cannot send that sheet as an attached file on its own.
gt;
gt; Semantics playing a part here, I do believe.
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Thu, 27 Apr 2006 10:49:03 -0700, Sandy gt;
gt; wrote:
gt;
gt; gt;Peo...thanks for getting back to me...I disagree with you...you can/could
gt; gt;email a single worksheet in a workbook...we have done it with Excel 2003 and
gt; gt;we could do it before with outlook....
gt; gt;
gt; gt;--
gt; gt;Stellier
gt; gt;
gt; gt;
gt; gt;quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt;gt; You can't email a single sheet, never could. The only way manually is to
gt; gt;gt; copy the particular sheet to a new workbook and mail that workbook.
gt; gt;gt; Otherwsie you would need VBA.
gt; gt;gt;
gt;
gt;

Hi Sandy

You are correct

See number 3
www.rondebruin.nl/mail/problems.htm

--
Regards Ron de Bruin
www.rondebruin.nlquot;Sandyquot; gt; wrote in message ...
gt; Gord
gt; I didn't select a range I just was on a particular sheet and did the
gt; email...mind you the receipent sees this huge page...but you don't have to
gt; select a range...I guess the answer to my question is if you are on the
gt; Exchange 2003 for email you should be on Office 2003 also.
gt; --
gt; Stellier
gt;
gt;
gt; quot;Gord Dibbenquot; wrote:
gt;
gt;gt; Sandy
gt;gt;
gt;gt; You can email selected range(s) from a worksheet as a quot;message bodyquot; but you
gt;gt; cannot send that sheet as an attached file on its own.
gt;gt;
gt;gt; Semantics playing a part here, I do believe.
gt;gt;
gt;gt;
gt;gt; Gord Dibben MS Excel MVP
gt;gt;
gt;gt; On Thu, 27 Apr 2006 10:49:03 -0700, Sandy gt;
gt;gt; wrote:
gt;gt;
gt;gt; gt;Peo...thanks for getting back to me...I disagree with you...you can/could
gt;gt; gt;email a single worksheet in a workbook...we have done it with Excel 2003 and
gt;gt; gt;we could do it before with outlook....
gt;gt; gt;
gt;gt; gt;--
gt;gt; gt;Stellier
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;quot;Peo Sjoblomquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; You can't email a single sheet, never could. The only way manually is to
gt;gt; gt;gt; copy the particular sheet to a new workbook and mail that workbook.
gt;gt; gt;gt; Otherwsie you would need VBA.
gt;gt; gt;gt;
gt;gt;
gt;gt;
Could there be a semantic difference in the way people are responding to the
question.

I could use xl2003 to email a single worksheet, but it surely wasn't a single
worksheet when I received it.

I remember a couple of guys going out to see my brand new 1984 Datsun 210. One
asked if the driver side mirror folded in.

I said no.

The third guy said: Yes it will--once.

I can't believe this helps, but I do like that story.

Ron de Bruin wrote:
gt;
gt; Hi Sandy
gt;
gt; You are correct
gt;
gt; See number 3
gt; www.rondebruin.nl/mail/problems.htm
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt; quot;Sandyquot; gt; wrote in message ...
gt; gt; Gord
gt; gt; I didn't select a range I just was on a particular sheet and did the
gt; gt; email...mind you the receipent sees this huge page...but you don't have to
gt; gt; select a range...I guess the answer to my question is if you are on the
gt; gt; Exchange 2003 for email you should be on Office 2003 also.
gt; gt; --
gt; gt; Stellier
gt; gt;
gt; gt;
gt; gt; quot;Gord Dibbenquot; wrote:
gt; gt;
gt; gt;gt; Sandy
gt; gt;gt;
gt; gt;gt; You can email selected range(s) from a worksheet as a quot;message bodyquot; but you
gt; gt;gt; cannot send that sheet as an attached file on its own.
gt; gt;gt;
gt; gt;gt; Semantics playing a part here, I do believe.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; Gord Dibben MS Excel MVP
gt; gt;gt;
gt; gt;gt; On Thu, 27 Apr 2006 10:49:03 -0700, Sandy gt;
gt; gt;gt; wrote:
gt; gt;gt;
gt; gt;gt; gt;Peo...thanks for getting back to me...I disagree with you...you can/could
gt; gt;gt; gt;email a single worksheet in a workbook...we have done it with Excel 2003 and
gt; gt;gt; gt;we could do it before with outlook....
gt; gt;gt; gt;
gt; gt;gt; gt;--
gt; gt;gt; gt;Stellier
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;quot;Peo Sjoblomquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; You can't email a single sheet, never could. The only way manually is to
gt; gt;gt; gt;gt; copy the particular sheet to a new workbook and mail that workbook.
gt; gt;gt; gt;gt; Otherwsie you would need VBA.
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;

--

Dave Peterson

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
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Sandyquot; gt; wrote in message
...
gt; Peo...I was just at the computer that has Office 2003...when you click on
gt; the
gt; letter/envelope on the tool bar you get the following
gt; message...Email...you
gt; can send the entire workbook as an attachment to an email message or send
gt; the
gt; current sheet as the body of an email message..the you get 2 choices...1st
gt; choice is send the entire workbook as an attachment ..2nd choice is send
gt; the
gt; current sheet as the message body...I selected the message body and it
gt; works...why not with office 2000 and Exchange 2003.
gt;
gt; --
gt; Stellier
gt;
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; How? Unless you have an add-in which would go under quot;Otherwise you would
gt;gt; need VBA.quot;
gt;gt; it is not possible
gt;gt;
gt;gt;
gt;gt;
gt;gt; Peo
gt;gt;
gt;gt;
gt;gt; quot;Sandyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Peo...thanks for getting back to me...I disagree with you...you
gt;gt; gt; can/could
gt;gt; gt; email a single worksheet in a workbook...we have done it with Excel
gt;gt; gt; 2003
gt;gt; gt; and
gt;gt; gt; we could do it before with outlook....
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; Stellier
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Peo Sjoblomquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; You can't email a single sheet, never could. The only way manually is
gt;gt; gt;gt; to
gt;gt; gt;gt; copy the particular sheet to a new workbook and mail that workbook.
gt;gt; gt;gt; Otherwsie you would need VBA.
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt;
gt;gt; gt;gt; Regards,
gt;gt; gt;gt;
gt;gt; gt;gt; Peo Sjoblom
gt;gt; gt;gt;
gt;gt; gt;gt; nwexcelsolutions.com
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Sandyquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; We are having a problem trying to email a single worksheet since we
gt;gt; gt;gt; gt; have
gt;gt; gt;gt; gt; installed Exhcange 2003. We are running Office 2000. We can email
gt;gt; gt;gt; gt; the
gt;gt; gt;gt; gt; whole
gt;gt; gt;gt; gt; workbook but not just a sheet. We get a microsoft excel error
gt;gt; gt;gt; gt; message
gt;gt; gt;gt; gt; that
gt;gt; gt;gt; gt; says Excel could not start the e-mail program. Check your network
gt;gt; gt;gt; gt; connection.
gt;gt; gt;gt; gt; Make sure Office is installed correctly, your email program is setup
gt;gt; gt;gt; gt; correctly and you can connect to your email server. We have done all
gt;gt; gt;gt; gt; of
gt;gt; gt;gt; gt; this.
gt;gt; gt;gt; gt; I thinkg that it might be the Office 2000 and Exchange 2003.
gt;gt; gt;gt; gt; Thanks
gt;gt; gt;gt; gt; --
gt;gt; gt;gt; gt; Stellier
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;