View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LESLIE LESLIE is offline
external usenet poster
 
Posts: 113
Default 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!