Create a "Send" button
I have created a form using Excel. I would like the people who fill out his
form to click a €śSubmit This Form€ť button at the top of his form and have
this button e-mail the form file to me (with the form file as an attachnemt
to the e-mail).
I need to know how to create a button in an Excel file, so that when you
click this button, it generates an e-mail addressed to a pre-specified
recipient (e-mail would be pre-addressed to me) with the completed form file
as an attachment to the e-mail.
I have a lot of experience working with Excel, so if possible, Id prefer to
do this using a hyperlink and the capabilities of Excel, without using Visual
Basic. Is there a way to do what I need to do using Excel?
If Visual Basic is the only way this can be done, can you walk me through
the process of creating a button (and help me write the macro language) to do
this? (I have very little experience with Visual Basic!)
Thank you so much for your help!
|