Need to copy and paste range of cells to email body as image

[mattshef]

Hi everyone,

I have Bruin's code for inserting a range of cells to an e-mail as html. I need to find a way to do the same thing, but insert the range of cells as an image into the email. Many of the people at my work are receiving these e-mails on their smartphones and the formatting of the HTML text goes away when they view the e-mail. I am hoping that if I paste it is an image, it will display properly on their phones.

I appreciate the help!

Matt

 

[Comfy]

This article has code that will do what you ask: VBA Useful : Automate Repetitive Tasks in Excel: Send HTML email with embedded Images

I would suggest removing the HTML that specifies the size of the picture.

<img src='cid:DashboardFile.jpg'>

One more thing, I would add a line or two to delete the Temp file once it has been attached and sent.