View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.outlook,microsoft.public.outlook.program_vba
Paul W Smith Paul W Smith is offline
external usenet poster
 
Posts: 74
Default 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" wrote in message
...
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" wrote in message
...
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