sending email with a Picture in the body

Hi all,

I have a process metric that I need to send via email.
I would like to automate this.

I am looking for the following
1. upon clicking send mail button the smart art used on the excel should be mailed.
2. the smart art should be pasted as Image on the body of the email.
3. The body should contain a text message like " dear receiver," <line break> " Please find the below process health for this week" <line break> "Regards," <line break> "Sender"
4. The size of the image on the email body should be height 3 inches and width should be 5 inches.

I have attached the spreadsheet for reference.
Looking for help from you guys.

Thanks,
Kiran

Hi All,

Need you help with the below situation.

Originally Posted by jaslake

Hi kiranpat

See if the Code in the attached works for you...

Thanks for your help however, I see an error msg at line pic.Chart.Export "C:\bazooka.bmp"
I have attached a screen shot of it for your reference.

Originally Posted by jaslake

Hi kiranpat

I can only guess, have no way of trouble shooting it for you as it works on my platform. My guess is you either can't write to Drive C or you don't have a Drive C. In either event, if one or the other is true, you'll need to change the Reference from Drive C to one to which you can write.

Hi jaslake,

May be you are right, just was thinking if we can do it without using the drive.
like using the cache memory?
just thinking, any idea it that can be done?

Originally Posted by jaslake

Hi kiranpat

No clue

Thanks for the reply jaslake, I will try the code on a different machine and will let you know if it works

Originally Posted by jaslake

Let me know how I can help...

Thanks a lot Jaslake, I changed the path to D drive an it perfectly works fine now.