Macro to take a screenshot and bundle into body of Outlook

This is only my 3rd VBA that I am working on and struggling to get something where I can:
- take a screenshot of 'part' of an excel worksheet
- paste it in the 'body' of an email

I have tried much googling but no luck. I found this but not quite able to make it work/understand it.

Please Login or Register  to view this content.

Here is what I have written so far. Sorry if its so messy ... like I said, its only my 3rd one.

Please Login or Register  to view this content.

Any specific details/explanation would be appreciated. Thanks in 'advance' for your help.

Kathleen

I have made a bit more headway but I just cant wrap my head around what to do next. I have found this macro that I can tell works cause when I run it and then open WORD and just do a ctrl+v it actually pastes the screenshotthat I was expecting in. But how do I get the paste command and combine it with the rest of my code (ie: to, subject, body, etc)

Here is the 'copy' code I found:

Please Login or Register  to view this content.

Honest I am trying ...

The range is fixed (A11:K22) and will never change. Here is the spreadsheet I am working with attached.