Adding Excel Chart objects to an Outlook mail body

[lico13]

Adding Excel Chart objects to an Outlook mail body


Hi friends,


I hope you can help me here… I tried to find solutions for my need but didn’t succeed to implement any of them…


The attached VBA code sends an automated mail through Outlook to few people in a weekly basis, and contains text in the body and attached Excel file. This code was written in ‘ThisOutlookSession’ in Outlook VBA (based on recurrent task created in Outlook) and works perfect!


I would like to add to the code the following action:
Enter the Excel file: C:\folder\file.xlsm (the file that was attached to the mail by VBA)
Go to Sheet A and copy Chart X (chart object name X)
Go to Sheet B and copy Chart Y (chart object name Y)
Go to Sheet C and copy Chart Z (chart object name Z)
Paste these 3 copied charts in the same mail body, one by another, after the text lines “Bla Bla…”.
Above every chart add its relevant header text (Chart X / Y / Z)
At the end of the process, Excel file should be closed with no changes in it.


Please try to help me editing the current code with the needed additions.
I’ll be happy to have your support.


Thanks in advance 😊