Paste range as bitmap and send Outlook email

[kamparius]

Hi everyone,

I've seen a few threads around the internet about this, but none of them seems to quite solve the issue. As I don't have much VBA experience, was hoping someone here might be able to help!

As this is a task I have to repeat many time per day, I'm hoping that the code would:

1) Open a new blank email message in Outlook
2) Copy the range A1 to R31 of the currently open workbook and worksheet of Excel
3) Paste that range into the BODY of the email as a PICTURE
4) Send email to a few email addresses with subject "Update"

Thanks in advance for your help!

 

[Diego_]

If you're ok with having the range embedded in the body of the email, have a look at Ron de Bruin's website page on Excel / Outlook :

Mail from Excel with Outlook (VBA)

 

[kamparius]

If you're ok with having the range embedded in the body of the email, have a look at Ron de Bruin's website page on Excel / Outlook :

Mail from Excel with Outlook (VBA)

Hi Diego - thank you very much for answering. I have looked at Ron's website already, but couldn't seem to find what I'm looking for. Because the range contains text as well as charts, I'm hoping to select the whole thing and paste the whole things as a picture, rather than use embedded html...