Need help copying a picture/image from excel to the body of an outlook email

Hello All,

This is my first post ever. Prior to now, I have been able to find solutions using other people's posts. This site has been a huge help in getting over various hurddles. Thank you all.

Anyway, here is my current problem. I have a report that I send out weekly. I have a macro that imports the data, runs some calculations and produces a nicely formatted report. I recently added a macro to send this report via email with the help of code I found on this forum. My boss asked me to add an image to the report (our departments branding). The problem is that the picture/image doesn't paste over into the body of the email. The values and formats within the range ("A1:L8") copy over, but the picture/image within that range does not.

From what I can tell, by the time "rng.Copy" is called in the RangetoHTML function the picture/image is gone.

Thank you in advance for any assistance.

Here's the code:

Please Login or Register  to view this content.