Excel graphs pasted into Outlook message are huge

[RobBroekhuis]

I frequently compose email messages with embedded charts from Excel. My modus operandi has always been to create the chart in Excel (on a chart sheet), selecting and copying the chart, and then in Outlook doing a "Paste Special" into a message, choosing Windows Metafile as the format. The resulting message would take up perhaps 30kb.
My company recently switched to Office 2007. Now when I do the same thing, the message balloons to 1MB. Trying all the other options in the Paste Special menu results in the same or even larger sizes. I can't find a way to reduce the size of the embedded object. Any ideas?

Rob

 

[tf1]

Download one of the great free graphics apps you can get today: I recommend either either IrfanView or Paint.NET (the latter being slightly better if you want to edit digital photos, the former because of all the graphics formats it supports). Create your chart in Excel and then copy/paste it into the graphics editor.

In the editor, use the resize/resample tool to select 96dpi (or 200dpi if they are to be printed) and set the size you need and save the result as a jpeg.

In an Outlook email, use Insert File to get the charts into the email.


Regards: tf1