How to email charts using Excel
 

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