Sending to mail recipient from Excel
I have developed a form that users can use in Excel to order Maintenance work within their company. The only problem I am having is sending this sheet to the Maintenance department. Manually I can do this if I am in the worksheet that I want to send and I select "File" From the tool bar and then select "Send to Mail Recipient". This then opens the outlook window where you can enter the address for the recipient and subsequently send the message. I want this to be automatic at the click of a button. Can this be done?