Paste range as image into mail body

kirbyfez

Board Regular
Joined
May 15, 2012
Messages
51
Hi all,

I've been looking around like crazy trying to find a way to send an range from excel via email in the body as an image.

Found multiple ways of doing it with either an attachment or HTML but both really wont work for me.

The reason html wont work is because I have some formatting which really looks awful in HTML.

Anyone here that has any guides or a code I can use/manipulate which could work.

Basically the plan is that I have a set of named ranged and corresponding emails so I want it to find the named range and send it via email as an image.. Bitmap, jpg whatever really.

I got everything working with a good loop but i just can't get the paste as image working.

Any help would be appreciated!
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,215,596
Messages
6,125,728
Members
449,255
Latest member
whatdoido

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top