Improve image quality while pasting it to outlook body

[Ehtisham Ali]

Hi All,

I have designed a daily performance summary dashboard for my project which I broadcast through email. I paste the whole dashboard as Picture in outlook body.

Initially I used to do this manually but now I have a code which automatically does the job with a little concern. The quality of Image is not satisfactory.

Module name in attached workbook is "automail". I request you to please go through the code and suggest me some workaround to improve the overall quality.

I have attached my Macro Workbook for your reference.

Below is the screenshot of poor quality image from outlook body.



I am waiting for your creative ideas as always

 

[Ehtisham Ali]

Hi Guys,

Anyone please give some ideas.

 

[Chihiro]

As far as I know, Excel can only export as low res PNG. You may need to export as EMF (Windows enhanced metafile format). Some of the link may help (not tested).

http://ckannan.blogspot.ca/2012/06/export-excel-chart-as-vector-image-wmf.html

http://windowssecrets.com/forums/sh...VBA-to-Export-an-XL-Chart-(VBA-Excel-XP-2002)

https://social.msdn.microsoft.com/F...gpng-with-high-resolution-in-vba?forum=isvvba

 

[Debaser]

I'd suggest two things:
1. Use Stephen Bullen's PastePicture module (as in the attached version of your file)
2. Never ever ever ever ever ever use 3D pie charts for anything. Ever.

 

[Ehtisham Ali]

I'd suggest two things:
1. Use Stephen Bullen's PastePicture module (as in the attached version of your file)
2. Never ever ever ever ever ever use 3D pie charts for anything. Ever.

Hi Debaser,

Can you do me favour. Please apply the Stephen Bullen's code to my existing code as you said.

I tried but had no luck.

 

[Debaser]

It was in the file I attached.