VBA Code to Paste copied range as a picture

Good afternoon,

Im trying to create a code that will copy the contents in a range to outlook and then email the relevant parties, i have managed to achieve this but when the contents copy and paste the information into outlook its all over the place so i would like to amend this code to paste the contents as a Paste Special picture. Could anyone help me with this?

Yours gratefully, DJ

Please Login or Register  to view this content.

Ron deBruin has an excellent set of examples on code for sending mail from excel check this out:
http://www.rondebruin.nl/sendmail.htm

Ive seen the link above before but i dont know where i need to place the extra bit of code im my current query, that what i would like some help for. Thank you

The method you are using will always send an excel sheet, what you need is the code below. Test it and if it works please add some reputation by clicking the * below.
Please note this is a modified version of the code by DeBruin as I mentioned in my previous post.

Please Login or Register  to view this content.

I am after the same thing. I want VBA to copy a range in excel and paste it into an outlook email as a picture, not a table. It would be the equivalent of selecting a range in excel, Ctrl+C, then opening an outlook email, right clicking in the body, then under Paste Options clicking the Paste Picture icon (looks like a mountain range with a sun in the top right).

RaulRodriquez, your code (using both Sxbody and rng) accomplishes the same result as Ron deBruin's code, which I've been using for months now as my code's basis, but I want to have the picture pasted now; your code ends up with a pasted table of the original range in the outlook email.

Now get it to paste a picture of the range, and that would be just perfect!