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!

"Leslie" wrote in message
...
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, I'd 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!



Hi Leslie

This link has al the data you will need

http://www.rondebruin.nl/sendmail.htm

Best N10