How to get screenshot of data range from an excel tab in to email along with attachment

[Mahendra S]

Greeting to my fellow forum members.

I was searching for sending emails with attachments using vba and interestingly found one of the thread (send-mails-using-excel-vba-and-outlook).
The code given in above example is good I believe and I'am sure others might have customized or enhanced to their needs.

Requirement1: Here is a situation where I need to get a screenshot of data range from one of the tab and bring this screenshot range as an image with in the body of the email.

For example If I have multiple Tabs in spreadsheet file, (like rawData, rawData1, etc)
is it possible to capture Data Range ($B1 to $M10) from rawData1 Tab and inserted in the email body.

attaching the template file (email-screenshots.xlsm)
Appreciate any help with this.

Regards,
Mahendra

 

[Deepak]

Hi,

Mr ron has several stuff on the same, Pls check.


http://www.rondebruin.nl/win/s1/outlook/bmail3.htm

 

[Mahendra S]

Thank you for sending ron's link, will try to verify how this works via a procedure call.