VBA to email Chart in body of email

[smudgers9]

Hi,

There are previous posts about this but quite old and I have been unable to get them to work without getting Run-time error '9': Subscript out of range. Hoping someone will be able to assist. The objective is to generate an email which includes the chart (Chart 1) from Sheet2 into the body of an email with pre written text (to be decided upon).
Any assistance would be greatly appreciated.

Please Login or Register  to view this content.

[KOKOSEK]

[smudgers9]

Thanks KOKESEK, but I'm still getting the same error. My code is below. I'm sure it's something simple but I'm missing it.

Please Login or Register  to view this content.

[KOKOSEK]

What line generates error? Did you check path in general? Privileges to write into declared path? etc.

[smudgers9]

Hi KOKOSEK, I knew it would be something stupid. I had renamed the sheet but it was still being referenced by the old name. Corrected and now it works. Perfect. Thanks for the help.