How do you set up a submit button to attach worksheet in email?

I am doing a form and I want to have a submit or send link on the bottom of
the page. I know how to make hyperlinks but I dont know how to get it where
when the user hits the send button it automatically saves that info and sends
that form to the intended email address. Basically so you dont have to attach
it yourself through email. Is there a way to do this?

Have a look here for code to send mail

http://www.rondebruin.nl/sendmail.htm#Tips
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"[email protected]"
<[email protected]@discussions.microsoft.com> wrote in message
news:[email protected]...
>I am doing a form and I want to have a submit or send link on the bottom of
> the page. I know how to make hyperlinks but I dont know how to get it
> where
> when the user hits the send button it automatically saves that info and
> sends
> that form to the intended email address. Basically so you dont have to
> attach
> it yourself through email. Is there a way to do this?