I have a protected Exel form which works very nicely. We
have put it on our intranet, and would like to have a
command button at the bottom of the form to send the
filled out form to a specific email address. I don't know
if it is a series of steps such as programatically doing a
file save as.. and opening a email putting a subject line
in the and sending, or if it is as easy as
incorporating a mailto: . I'm just
guessing! It would be nice to display a dialog box at the
end that says "Form has been submitted, to save a copy
locally you must use the File, Save As... command" and an
OK button.

Could someone please send me a code snippet, which I image
would be put in the command button click event.

Thank you in advance
God bless you