Main Page 
PC Review
Forums
Newsgroups
Microsoft Outlook
Microsoft Outlook VBA Programming
Emailing Activesheet As Body of Email
Forums
Newsgroups
Microsoft Outlook
Microsoft Outlook VBA Programming
Emailing Activesheet As Body of Email
 |
Emailing Activesheet As Body of Email |
|
|
Thread Tools | Rate Thread |
15-12-2007, 12:50 PM
|
#1 |
|
Guest
Posts: n/a
|
Emailing Activesheet As Body of Email
I want to be able to send the contents of a Excel range in an Email. I do
not want to send it as an attachment, I want it in the body of an Email. The Excel page contains a logo graphic which is the problem using all the methods on Ron de Bruin's page, as I understand them. I cannot see to find a way to send the page and logo (without using the Activesheet.MailEnvelope). Can anyone suggest a method of sending an Excel range in an Email, including any graphics on the sheet. PWS |
|
|
15-12-2007, 01:11 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: Emailing Activesheet As Body of Email
Hi Paul
Activesheet.MailEnvelope is the only good way on this moment I am working on a CDO way but this one is not ready yet -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Paul W Smith" <pws@NOSPAM.twelve.me.uk> wrote in message news:%23Mr3gkxPIHA.3388@TK2MSFTNGP03.phx.gbl... >I want to be able to send the contents of a Excel range in an Email. I do > not want to send it as an attachment, I want it in the body of an Email. > > The Excel page contains a logo graphic which is the problem using all the > methods on Ron de Bruin's page, as I understand them. > > I cannot see to find a way to send the page and logo (without using the > Activesheet.MailEnvelope). > > Can anyone suggest a method of sending an Excel range in an Email, including > any graphics on the sheet. > > PWS > > > |
|
|
|
15-12-2007, 07:15 PM
|
#3 |
|
Guest
Posts: n/a
|
Re: Emailing Activesheet As Body of Email
Thanks Ron for the update.
I am being pressured at work to provide a solution hence my second post, I was hoping that it therew as a way to include the graphic without using Activesheet.MailEnvelope, I coud addapt the solution you provided a couple of days ago. Obviously as an MVP you have access to Microsoft others do not have, have you invetsigated the possibility of getting some documentation on the MailEnvelope. It seems to strange to me that you can set the .subject and ..Recipients properties, but apparently not any form of From or ReplyTo property. I have Microsoft Premier support at my company, but if you have already investigated this I will not waste their time further. PWS "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:%23OHD2vxPIHA.4684@TK2MSFTNGP02.phx.gbl... > Hi Paul > > Activesheet.MailEnvelope is the only good way on this moment > I am working on a CDO way but this one is not ready yet > > -- > > Regards Ron de Bruin > http://www.rondebruin.nl/tips.htm > > > "Paul W Smith" <pws@NOSPAM.twelve.me.uk> wrote in message > news:%23Mr3gkxPIHA.3388@TK2MSFTNGP03.phx.gbl... >>I want to be able to send the contents of a Excel range in an Email. I do >>not want to send it as an attachment, I want it in the body of an Email. >> >> The Excel page contains a logo graphic which is the problem using all the >> methods on Ron de Bruin's page, as I understand them. >> >> I cannot see to find a way to send the page and logo (without using the >> Activesheet.MailEnvelope). >> >> Can anyone suggest a method of sending an Excel range in an Email, >> including any graphics on the sheet. >> >> PWS >> >> |
|
|
|
15-12-2007, 07:25 PM
|
#4 |
|
Guest
Posts: n/a
|
Re: Emailing Activesheet As Body of Email
Hi Paul
They also hide this option in Excel 2007. I not like the MailEnvelope code because it will use the Excel screen and you must have Outlook setup as your default account. I always have OE as default. Drop me a mail private so I can send you a mail when the CDO code when it is working correct. I will work on it next week. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Paul W Smith" <pws@NOSPAM.twelve.me.uk> wrote in message news:um0ch70PIHA.1188@TK2MSFTNGP04.phx.gbl... > Thanks Ron for the update. > > I am being pressured at work to provide a solution hence my second post, I > was hoping that it therew as a way to include the graphic without using > Activesheet.MailEnvelope, I coud addapt the solution you provided a couple > of days ago. > > Obviously as an MVP you have access to Microsoft others do not have, have > you invetsigated the possibility of getting some documentation on the > MailEnvelope. It seems to strange to me that you can set the .subject and > .Recipients properties, but apparently not any form of From or ReplyTo > property. > > I have Microsoft Premier support at my company, but if you have already > investigated this I will not waste their time further. > > PWS > > > > "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message > news:%23OHD2vxPIHA.4684@TK2MSFTNGP02.phx.gbl... >> Hi Paul >> >> Activesheet.MailEnvelope is the only good way on this moment >> I am working on a CDO way but this one is not ready yet >> >> -- >> >> Regards Ron de Bruin >> http://www.rondebruin.nl/tips.htm >> >> >> "Paul W Smith" <pws@NOSPAM.twelve.me.uk> wrote in message >> news:%23Mr3gkxPIHA.3388@TK2MSFTNGP03.phx.gbl... >>>I want to be able to send the contents of a Excel range in an Email. I do >>>not want to send it as an attachment, I want it in the body of an Email. >>> >>> The Excel page contains a logo graphic which is the problem using all the >>> methods on Ron de Bruin's page, as I understand them. >>> >>> I cannot see to find a way to send the page and logo (without using the >>> Activesheet.MailEnvelope). >>> >>> Can anyone suggest a method of sending an Excel range in an Email, >>> including any graphics on the sheet. >>> >>> PWS >>> >>> > |
|
|
|
15-12-2007, 07:32 PM
|
#5 |
|
Guest
Posts: n/a
|
Re: Emailing Activesheet As Body of Email
ActiveSheet.MailEnvelope.Item returns an Outlook.MailItem that works just like any other: Reply recipients are set through the ReplyRecipients collection. There is no direct way to set the sender, although providing a value to the SentOnBehalfOfName property will work in some scenaros.
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Paul W Smith" <pws@NOSPAM.twelve.me.uk> wrote in message news:um0ch70PIHA.1188@TK2MSFTNGP04.phx.gbl... > Thanks Ron for the update. > > I am being pressured at work to provide a solution hence my second post, I > was hoping that it therew as a way to include the graphic without using > Activesheet.MailEnvelope, I coud addapt the solution you provided a couple > of days ago. > > Obviously as an MVP you have access to Microsoft others do not have, have > you invetsigated the possibility of getting some documentation on the > MailEnvelope. It seems to strange to me that you can set the .subject and > .Recipients properties, but apparently not any form of From or ReplyTo > property. > > "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message > news:%23OHD2vxPIHA.4684@TK2MSFTNGP02.phx.gbl... >> Hi Paul >> >> Activesheet.MailEnvelope is the only good way on this moment >> I am working on a CDO way but this one is not ready yet >> >> -- >> >> Regards Ron de Bruin >> http://www.rondebruin.nl/tips.htm >> >> >> "Paul W Smith" <pws@NOSPAM.twelve.me.uk> wrote in message >> news:%23Mr3gkxPIHA.3388@TK2MSFTNGP03.phx.gbl... >>>I want to be able to send the contents of a Excel range in an Email. I do >>>not want to send it as an attachment, I want it in the body of an Email. >>> >>> The Excel page contains a logo graphic which is the problem using all the >>> methods on Ron de Bruin's page, as I understand them. >>> >>> I cannot see to find a way to send the page and logo (without using the >>> Activesheet.MailEnvelope). >>> >>> Can anyone suggest a method of sending an Excel range in an Email, >>> including any graphics on the sheet. >>> >>> PWS >>> >>> > |
|
|
|
16-12-2007, 10:00 AM
|
#6 |
|
Guest
Posts: n/a
|
Re: Emailing Activesheet As Body of Email
Is there a way of setting the ReplyTo address when using
Activesheet.MailEnvelope? PWS "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message news:u8VcQF1PIHA.4136@TK2MSFTNGP03.phx.gbl... ActiveSheet.MailEnvelope.Item returns an Outlook.MailItem that works just like any other: Reply recipients are set through the ReplyRecipients collection. There is no direct way to set the sender, although providing a value to the SentOnBehalfOfName property will work in some scenaros. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Paul W Smith" <pws@NOSPAM.twelve.me.uk> wrote in message news:um0ch70PIHA.1188@TK2MSFTNGP04.phx.gbl... > Thanks Ron for the update. > > I am being pressured at work to provide a solution hence my second post, I > was hoping that it therew as a way to include the graphic without using > Activesheet.MailEnvelope, I coud addapt the solution you provided a couple > of days ago. > > Obviously as an MVP you have access to Microsoft others do not have, have > you invetsigated the possibility of getting some documentation on the > MailEnvelope. It seems to strange to me that you can set the .subject and > .Recipients properties, but apparently not any form of From or ReplyTo > property. > > "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message > news:%23OHD2vxPIHA.4684@TK2MSFTNGP02.phx.gbl... >> Hi Paul >> >> Activesheet.MailEnvelope is the only good way on this moment >> I am working on a CDO way but this one is not ready yet >> >> -- >> >> Regards Ron de Bruin >> http://www.rondebruin.nl/tips.htm >> >> >> "Paul W Smith" <pws@NOSPAM.twelve.me.uk> wrote in message >> news:%23Mr3gkxPIHA.3388@TK2MSFTNGP03.phx.gbl... >>>I want to be able to send the contents of a Excel range in an Email. I >>>do >>>not want to send it as an attachment, I want it in the body of an Email. >>> >>> The Excel page contains a logo graphic which is the problem using all >>> the >>> methods on Ron de Bruin's page, as I understand them. >>> >>> I cannot see to find a way to send the page and logo (without using the >>> Activesheet.MailEnvelope). >>> >>> Can anyone suggest a method of sending an Excel range in an Email, >>> including any graphics on the sheet. >>> >>> PWS >>> >>> > |
|
|
|
16-12-2007, 02:48 PM
|
#7 |
|
Guest
Posts: n/a
|
Re: Emailing Activesheet As Body of Email
Yes, as I said, you need to return ActiveSheet.MailEnvelope.Item, which is a MailItem, and then work with its ReplyRecipients collection, just as you would its Recipients. Use the Add method.
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Paul W Smith" <pws@NOSPAM.twelve.me.uk> wrote in message news:%23c2Q0p8PIHA.4912@TK2MSFTNGP06.phx.gbl... > Is there a way of setting the ReplyTo address when using > Activesheet.MailEnvelope? > > PWS > > > "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message > news:u8VcQF1PIHA.4136@TK2MSFTNGP03.phx.gbl... > ActiveSheet.MailEnvelope.Item returns an Outlook.MailItem that works just > like any other: Reply recipients are set through the ReplyRecipients > collection. There is no direct way to set the sender, although providing a > value to the SentOnBehalfOfName property will work in some scenaros. > > "Paul W Smith" <pws@NOSPAM.twelve.me.uk> wrote in message > news:um0ch70PIHA.1188@TK2MSFTNGP04.phx.gbl... >> Thanks Ron for the update. >> >> I am being pressured at work to provide a solution hence my second post, I >> was hoping that it therew as a way to include the graphic without using >> Activesheet.MailEnvelope, I coud addapt the solution you provided a couple >> of days ago. >> >> Obviously as an MVP you have access to Microsoft others do not have, have >> you invetsigated the possibility of getting some documentation on the >> MailEnvelope. It seems to strange to me that you can set the .subject and >> .Recipients properties, but apparently not any form of From or ReplyTo >> property. >> >> "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message >> news:%23OHD2vxPIHA.4684@TK2MSFTNGP02.phx.gbl... >>> Hi Paul >>> >>> Activesheet.MailEnvelope is the only good way on this moment >>> I am working on a CDO way but this one is not ready yet >>> >>> -- >>> >>> Regards Ron de Bruin >>> http://www.rondebruin.nl/tips.htm >>> >>> >>> "Paul W Smith" <pws@NOSPAM.twelve.me.uk> wrote in message >>> news:%23Mr3gkxPIHA.3388@TK2MSFTNGP03.phx.gbl... >>>>I want to be able to send the contents of a Excel range in an Email. I >>>>do >>>>not want to send it as an attachment, I want it in the body of an Email. >>>> >>>> The Excel page contains a logo graphic which is the problem using all >>>> the >>>> methods on Ron de Bruin's page, as I understand them. >>>> >>>> I cannot see to find a way to send the page and logo (without using the >>>> Activesheet.MailEnvelope). >>>> >>>> Can anyone suggest a method of sending an Excel range in an Email, >>>> including any graphics on the sheet. >>>> >>>> PWS >>>> >>>> >> > > |
|
|
|
17-12-2007, 04:55 PM
|
#8 |
|
Guest
Posts: n/a
|
Re: Emailing Activesheet As Body of Email
Hi Sue
I will add more info soon on my site about MailEnvelope. Playing with the CDO CreateMHTMLBody on this moment. Working great for WebPages online but still have a few problems with local htm files that I create with the VBA macro and send it. Do you have experience with it ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message news:%23PmKyK$PIHA.5264@TK2MSFTNGP02.phx.gbl... Yes, as I said, you need to return ActiveSheet.MailEnvelope.Item, which is a MailItem, and then work with its ReplyRecipients collection, just as you would its Recipients. Use the Add method. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Paul W Smith" <pws@NOSPAM.twelve.me.uk> wrote in message news:%23c2Q0p8PIHA.4912@TK2MSFTNGP06.phx.gbl... > Is there a way of setting the ReplyTo address when using > Activesheet.MailEnvelope? > > PWS > > > "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message > news:u8VcQF1PIHA.4136@TK2MSFTNGP03.phx.gbl... > ActiveSheet.MailEnvelope.Item returns an Outlook.MailItem that works just > like any other: Reply recipients are set through the ReplyRecipients > collection. There is no direct way to set the sender, although providing a > value to the SentOnBehalfOfName property will work in some scenaros. > > "Paul W Smith" <pws@NOSPAM.twelve.me.uk> wrote in message > news:um0ch70PIHA.1188@TK2MSFTNGP04.phx.gbl... >> Thanks Ron for the update. >> >> I am being pressured at work to provide a solution hence my second post, I >> was hoping that it therew as a way to include the graphic without using >> Activesheet.MailEnvelope, I coud addapt the solution you provided a couple >> of days ago. >> >> Obviously as an MVP you have access to Microsoft others do not have, have >> you invetsigated the possibility of getting some documentation on the >> MailEnvelope. It seems to strange to me that you can set the .subject and >> .Recipients properties, but apparently not any form of From or ReplyTo >> property. >> >> "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message >> news:%23OHD2vxPIHA.4684@TK2MSFTNGP02.phx.gbl... >>> Hi Paul >>> >>> Activesheet.MailEnvelope is the only good way on this moment >>> I am working on a CDO way but this one is not ready yet >>> >>> -- >>> >>> Regards Ron de Bruin >>> http://www.rondebruin.nl/tips.htm >>> >>> >>> "Paul W Smith" <pws@NOSPAM.twelve.me.uk> wrote in message >>> news:%23Mr3gkxPIHA.3388@TK2MSFTNGP03.phx.gbl... >>>>I want to be able to send the contents of a Excel range in an Email. I >>>>do >>>>not want to send it as an attachment, I want it in the body of an Email. >>>> >>>> The Excel page contains a logo graphic which is the problem using all >>>> the >>>> methods on Ron de Bruin's page, as I understand them. >>>> >>>> I cannot see to find a way to send the page and logo (without using the >>>> Activesheet.MailEnvelope). >>>> >>>> Can anyone suggest a method of sending an Excel range in an Email, >>>> including any graphics on the sheet. >>>> >>>> PWS >>>> >>>> >> > > |
|
|
|
17-12-2007, 07:44 PM
|
#9 |
|
Guest
Posts: n/a
|
Re: Emailing Activesheet As Body of Email
No, I confine my experiments to Outlook and don't do any work with CDO for Windows.
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:%23dIcw2MQIHA.5184@TK2MSFTNGP05.phx.gbl... > > I will add more info soon on my site about MailEnvelope. > > Playing with the CDO CreateMHTMLBody on this moment. > Working great for WebPages online but still have a few problems with local htm files > that I create with the VBA macro and send it. > > Do you have experience with it ? |
|
|
|
17-12-2007, 08:03 PM
|
#10 |
|
Guest
Posts: n/a
|
Re: Emailing Activesheet As Body of Email
Thanks Sue
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message news:OWMd3UOQIHA.2000@TK2MSFTNGP05.phx.gbl... No, I confine my experiments to Outlook and don't do any work with CDO for Windows. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:%23dIcw2MQIHA.5184@TK2MSFTNGP05.phx.gbl... > > I will add more info soon on my site about MailEnvelope. > > Playing with the CDO CreateMHTMLBody on this moment. > Working great for WebPages online but still have a few problems with local htm files > that I create with the VBA macro and send it. > > Do you have experience with it ? |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
