Problem with copying charts into html body outlook

Hello

I am attempting to copy one active sheet into html body outlook message.

I have the following code, which is adding the attachments however my charts still do not appear.

I am attempting to add one chart for now, but once complete will need to add all 5 from the page.

Any help with the code would be much, much appreciated.

Thank you

Please Login or Register  to view this content.

Hi and welcome to the forum. Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi,

Here's a section of code which I use to do this sort of thing.
The general idea is to create an empty 'chart' area that contains the stuff you want to put in the body of the email and create a temporary file that contains a picture of that area. Then use the temporary file name in the .htmlbody section of the Outlook email definition.

Please Login or Register  to view this content.

Hi,

I suspect your named range "email_range" is not in the sheet code name "emailsheet".

Since it is a named range and which is presumably meant to apply to single sheet try removing the reference to emailsheet and just use the range name.

Or modify the sheet name to that which contains the email_range

As far as I know you need to attach any images you want to include in the email if you want the recipient to see them.

If you have an image tag with the src path pointing to a local address on your computer then it's pretty unlikely the recipient will be able to access it.

I suppose if you were working on a network, saving the images to a shared drive then using the UNC path for the src might work.

How exactly did the original code not work?

So the problem with the original code was to do with the range and not the chart?

Does it work for the range on it's own?

Ah, OK

I think the problem with my original code is the Kill instruction. At the time the email is sent the file has already been deleted seemingly and the picture is not embedded You then get the red cross place marker.

Even introducing a wait of several seconds doesn't seem to overcome this. Leaving this instruction out sends the email as expected with the embedded picture.

However if as you say your code does not include the Kill instruction I'm puzzled since the routine works fine for - admittedly not on a network.

Richard

When someone receives the email can they see the chart/image?

Hi Norie,

Yes, but they need to be on the same network.

katekatebobs

Does it work if you add the image before the data?

Please Login or Register  to view this content.

Hi,

Here's another method taken from Ron de Bruin's pages which does seem to work fine.
Interestingly it's one of the few occasions when it's necessary to use the .Select instruction. Just using
Set sndRange = Range("myRange")
which would be the natural thing to do.
sends the email but with the whole sheet embedded.

Please Login or Register  to view this content.

Hi,

Is the pict1.gif file in the C:\Temp folder?