How to paste screenshot from excel worksheet in email body by VBA

[ThrottleWorks]

Hi,
I have 2-3 lines in excel.
Below these lines I have pasted a screenshot.
Below screenshot another 3-4 lines.

How do I paste this entire range in email body.
When I try with usual Ron De Bruin code, I am not able to get screenshot from excel in email body.

Can anyone please help me in this.

 

[Chihiro]

Try using method outlined in link to convert range to jpg.
http://vba-useful.blogspot.ca/2014/01/send-html-email-with-embedded-images.html

 

[ThrottleWorks]

Hi @Chihiro sir, thanks a lot for the help. Will check at home. Not able to check this website in office.

Have a nice day ahead.