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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message oups.com...
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

On Feb 15, 10:12 am, "Brad" wrote:
Take a look at the fine work done by Ron de Bruin in this area... his code
is easily modifiable.

www.rondebruin.nl

Brad

wrote in message

ups.com...

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??