How do I create a button on a worksheet for users to click on to send the
worksheet as an email to someone else. I want them to be able to click on a
button that will notify the office that their report is complete.

I have created a button and tried to record a macro but the email only sends
when I am recording the action, not when I click on the object later.

HELP