Excel

Email a chart in outlook

Ivan F Moala

Can Do

Visits here

Greatest place to be

Thanks for visiting my site lucky visitor:

Here is a routine that will email a selected Chart via Outlook.

The original idea and code was by DK (Daniel Klann) How ever when I tested it I realised that you really need to reference a URL in order for the Chart to come through, what we were actually seeing was a referenced link to our hard drive.

Thanks to Outlook MVP Neo this was able to be realised.

In Outlook, to create an HTML message that included an embedded image all <img> tags had to use full URLs to public web addresses. What we were actually seeing while viewing the tests were references to the hard drive image. Here is a method that uses undocumented MAPI properties and CDO.

CDO = Microsoft® Collaboration Data Objects

CDO does not represent a new messaging model, but rather an additional scripting interface to the Messaging Application Programming Interface (MAPI) model.

for more info see;

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdo/html/_olemsg_overview_of_cdo.asp

For versions see;

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncdsys/html/cdo_roadmap.asp

In VBA or Visual Basic you will need to add a reference to the CDO 1.21 library to use this procedure.

For client applications, you should install Outlook in order to install CDO.

In Outlook 2000 and Outlook 2002, CDO is included, but you must explicitly select it during setup.

Microsoft CDO 1.21 Library

MAPI

{3FA7DEA7-6438-101B-ACC1-00AA00423326}

C:\PROGRA~1\COMMON~1\System\Mapi\1033\NT\CDO.DLL

.AddFromGuid "{3FA7DEA7-6438-101B-ACC1-00AA00423326}",1,21

.Item("MAPI")

See generated chart image below

My thanks to Mark O'Brien for alerting me to the frustrating fact that the code pages do NOT copy, if at all

[COPY FRIENDLY PAGE]

Use scrollbar to scroll down to COPY BUTTON

If you cannot see the code in the code Window below, then click here.

This page was created on: June 9, 2003

Emailing a chart in Outlook may look complicated, but you won't need a computer degree to figure it out. A good online education in computer proficiency could help you become more comfortable with it. Learning computer languages is easier than learning Spanish!

This page was last updated: March 16, 2008