VBA Excel Range to Outlook as Image

[Frankinstyyn]

Hi all,

Hoping someone can help as Google can't get my specific request.

I would like to copy a range from sheet "F4T_AM" over to Outlook as an image and then to use .Display for now but then use .Send once I know it's working.

Below I have the code from the god Ron De Bruin. I am facing issues with getting the image into Outlook and highlighting the correct range.

At the moment, it puts it into another sheet and then to Outlook, if it could go straight from the "F4T_AM" page that would be awesome!

The below code deleted the image that may have already been there from an earlier run report, the report runs once a day, and then copies the table to another sheet.

Please Login or Register  to view this content.

The below code then completed the email outlook code.

Please Login or Register  to view this content.

Thanks in advance for all the help!

Frankinstyyn!

[gmr4evr1]

Try removing this from the Delete code

Please Login or Register  to view this content.

And in the SendEmail code change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Frankinstyyn]

Try removing this from the Delete code

Please Login or Register  to view this content.

And in the SendEmail code change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thanks for responding!

Okay, removed and amended and it still does as before.

Pastes it as a table without any dials or images.

The image on the left shows how it should look and the right is how it shows with the current code.

VBAOutlook.png

[gmr4evr1]

Is the image on the left a graph/chart?
This might be something that we would need a sample file of, with dummy data and all the arrows, graphs, code etc. that you are using.

[Frankinstyyn]

Is the image on the left a graph/chart?
This might be something that we would need a sample file of, with dummy data and all the arrows, graphs, code etc. that you are using.

No problem, thanks.

It's pictures, formulas and a few other things to be honest.

One of the reasons why I thought I could copy and paste into excel as Image and then copy the image to Outlook

Please see attached.

[gmr4evr1]

This has got me a bit stumped. See if the info on this site helps in any way..
http://www.rondebruin.nl/win/s1/outlook/mail.htm
Possibly this page within the site...
http://www.rondebruin.nl/win/s1/outlook/amail7.htm

[Frankinstyyn]

This has got me a bit stumped. See if the info on this site helps in any way..
http://www.rondebruin.nl/win/s1/outlook/mail.htm
Possibly this page within the site...
http://www.rondebruin.nl/win/s1/outlook/amail7.htm

I've had a look and can't seem to figure it out.

There might be a way to paste within the spreadsheet as a chart then open that in Outlook.

Either way, thanks for looking into it and helping!