sending worksheet by email using control button

Hi,

I have been going through old posts looking to find out how to send a worksheet to a fixed address using outlook and macros. I have found a number of posts on this but to me the answers seem to be in a foreign language.

Is there an easy way to automate this or will I need to study VBS.

I have set up a telephone directory for our company and would like to be able to offer staff the ability to send alterations using a macro in a worksheet automatically to me.


Any help you can give would be appreciated.