Emailing range problem???

[Johnny247]

Hi,
I have some code(below), that I am trying to use to select a range, then email as a picture.
However, it comes up with a syntax error in the first row.
Does anyone have any ideas on this please??

Thanks in advance.

Please Login or Register  to view this content.

[mrice]

Your line of code has spaces in it. May be you need something like (if the caption on the tab is Agency Order)

Please Login or Register  to view this content.

[Johnny247]

Thanks for that.
I have tried it again now with that line of code, but unfortunately, it now comes up with "Subscript out of Range". Do you have any suggestions please?
Thanks.
Johnny247

[Johnny247]

Figured it out! Thanks for your help ( It was the temp file path needed changing)