Macro to send worksheet to Outlook email

[jgeorg0310]

Hi,

I am not too familiar with macros. Is it possible to create a macro that will send a worksheet as an attachment to an Outlook email? I would like to create a "Submit" button at the bottom of my worksheet that will send the email if possible. Also, is it possible to have a dialogue box open after clicking "Submit" to confirm that the worksheet was sent? I would like the dialogue box to say "Your request has been submitted". Thanks in advance.