Exporting Pivot Table/Large Range as picture leads to very blurry image

[codeliftsleep]

Hello all,

I have been trying to automate sending emails with HTML in the body with embedded pictures/ranges. I have been able to get it to work using Ron de Bruin's RangeToHTML or with Images embedded but not both.

I thought I had a simple solution, just copy the ranges to a chart and export as an image, and it has worked very well except for one very large pivot table. This table has about 450-500 rows and needs to be included in the body of an email along with several other ranges and about 9 images.

So I have everything else working in HTML via creating an image, saving it as an hidden attachment and then referencing it in HTML like this:

.HTMLBody = "<img src='cid:MyPicName.png'/>"

and just adding <br>'s and the next image.

Everything works great, looks good, except for this pivot table/range. The picture turns out completely blurry and unreadable. I need to come up with some type of solution for this, but I'm not sure what I can do. I can use the Send Keys method I suppose to copy and paste it into the Email as a last resort, but that wouldn't be ideal.

Does anyone know a method to get it to save like it should as a picture without being unreadable?

 

[codeliftsleep]

Figured out that I can simply make it into 3 different pictures instead of 1 big one and it works out fine...