Hi,

I found the following piecd of code on google so that I could create a macro that replied to an email.. It works perfectly but my VBA programming skills are pretty basic so I don't really know how it works.

Please Login or Register  to view this content.

Basically if I email this to a colleague, they can then open it from the email, make chasnged and then press a button on the spreadsheet to send it back as a reply rather than a brand new email.

I want to doctor the code so that if it is not opened from an email attachment it still emails it, at the moment it's throwing up an error message.

Any help would be aprreciated.