email charts using Excel

  • Thread starter Thread starter utkarsh.varshney
  • Start date Start date
U

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??
 
Take a look at the fine work done by Ron de Bruin in this area... his code
is easily modifiable.



Brad
 
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
 
Back
Top