Exporting a chart into Outlook

[Robert A]

We have an Excel chart that we'd like to embed in an Outlook email, but
everytime we attempt to do this, the file size becomes tremendous - far
larger by megabytes compared to the original Excel file. We've tried all
methods, and the only way to minimize the size is to create a PDF
attachment. Is there another way?

Thanks,
Robert

--
___________________________
Robert Ades Accountancy Corp.
12100 Wilshire Blvd., Suite 660
Los Angeles, CA 90025
Tel: 310-571-1224
Fax: 310-571-1227

 

[Guest]

Is copying and pasting just the chart as a picture an option for you? The
file size should be quite small.

 

[Robert A]

Yes it is, but here's the odd thing about it. When the chart is first
pasted into Outlook, the image size is about 16kb. But once an attempt is
made to send the email, the file suddently grows to somthing like 3Mb. I am
at a loss to explain why this happens, but it does, repeatedly.

Robert Ades

 

[Jon Peltier]

Robert -

What starts small, perhaps in GIF format, gets itself expanded into a
full fledged bitmap, without any compression.

You could try exporting the chart in VBA:

ActiveChart.Export ActiveWorkbook.Path & "\MyChart.gif", "GIF"

Insert his line into a macro, or use it as is from the VB Editor's
Immediate Window. This exports it as a small GIF file into the same
directory as its parent workbook. You can then attach this file, and it
will stay small.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______