Email Button

[manualking]

Greetings,
I am curious as to if there is some way that I can create a button on an Excel worksheet that would send a request to a predetermined email recipient.
For example; I work at a catering company that uses a Microsoft Excel created document for the function sheets that we use to put together various catering and special events. Depending on the type of event and customer needs, we may or may not need waiters for the event; but the Dining Room Manager has to look through every function sheet to see if there’s a need for him to have to schedule a waiter; most of the time there isn’t a need. The same type of requests and procedure happens to the Maintenance department, Activities Department, etc. It goes without saying that a lot of time is spent looking through function sheets; and a lot of instructions are not seen as well. It would be wonderful if there could be a button for each Department that the Catering Coordinator could push in order to request assistance via email. Can this be done? Please help!

[gyclone]

Check out this:

http://www.makeuseof.com/tag/send-emails-excel-vba/

Lots more info can be found by googling "send email from Excel"