email charts using Excel

[utkarsh.varshney]

Hi All,

I need to automatically email(in a single mail) a number of charts(as
embedded in the email-body) using Excel.
I have coded in VBA such that Each chart is created in different
workbook.
How can I collate all of these and then send in a single mail??

Can somebody please help??

 

[Brad]

Take a look at the fine work done by Ron de Bruin in this area... his code
is easily modifiable.



Brad

 

[utkarsh.varshney]

Thx for this link. But it didn't solve my prob.
It has a code where chart can be send in the body of email, but with
the whole activesheet saved as an Html file.
What I want is, only the chart is send in the email.
Please read my query once again and help.

thx

 

[Ron de Bruin]

See this page
http://www.rondebruin.nl/mail/folder2/chart.htm