Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email a single worksheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email a single worksheet
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email a single worksheet
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email a single worksheet
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email a single worksheet
Sandy
You can email selected range(s) from a worksheet as a "message body" 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 wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email a single worksheet
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. -- Stellier "Gord Dibben" wrote: Sandy You can email selected range(s) from a worksheet as a "message body" 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 wrote: 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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email a single worksheet
Hi Sandy
You are correct See number 3 http://www.rondebruin.nl/mail/problems.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Sandy" wrote in message ... 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. -- Stellier "Gord Dibben" wrote: Sandy You can email selected range(s) from a worksheet as a "message body" 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 wrote: 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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email a single worksheet
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: Hi Sandy You are correct See number 3 http://www.rondebruin.nl/mail/problems.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Sandy" wrote in message ... 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. -- Stellier "Gord Dibben" wrote: Sandy You can email selected range(s) from a worksheet as a "message body" 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 wrote: 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. -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email a single worksheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print correct Page X of Y when printing single worksheet | Excel Discussion (Misc queries) | |||
lookup single value in entire worksheet | Excel Worksheet Functions | |||
Re-Calculation on a single worksheet | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Single worksheet, multiple pages? | Excel Discussion (Misc queries) |