Export All Excel Charts as Pics to Outlook

[aravindhan_31]

Hi,

Can you guyes help me for exporting all the excel charts as pics from the Activesheet to outlook mail box.
that is If a click a button, copy all the charts from the sheet1 and compose a new email from outlook and paste it in the body of the message.

Thanks for your help

Cross post:- http://www.vbaexpress.com/forum/showthread.php?t=38587

 

[Derek Brown]

That is not going to be easy - it would be better to attach them as PDF or PowerPoint presentation.
Have a look at:
http://help.wugnet.com/office/Insert-image-email-ftopict1039572.html