e-mail the current worksheet using a form button

I want to create a submit button that when I click on it, the current
worksheet/file will be e-mailed to someone. Instead of saving the
file, then inserting into an e-mail. I have seen this before in a
file before, but can't figure out exactly how it works. I happened to
notice in the VB Editor I saw something like...

CommandClick()
Excel.Application.Send "myname@email.com"
End Sub

Or something similar to that. I don't know any VBA.. So if that's
what I need to learn, then let me know.

TIA

Paul
Thu Jan 13 21:24:03 CST 2005

Richard, check out Ron's site for a LOT of information on this

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

--
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

"Richard Smack" <dicksmackdaily@hotmail.com> wrote in message
news:padeu094bvi2vf6fbn17p5opfnea2q7ikd@4ax.com...
> I want to create a submit button that when I click on it, the current
> worksheet/file will be e-mailed to someone. Instead of saving the
> file, then inserting into an e-mail. I have seen this before in a
> file before, but can't figure out exactly how it works. I happened to
> notice in the VB Editor I saw something like...
>
> CommandClick()
> Excel.Application.Send "myname@email.com"
> End Sub
>
> Or something similar to that. I don't know any VBA.. So if that's
> what I need to learn, then let me know.
>
> TIA

Richard
Thu Jan 13 22:59:24 CST 2005

Thanks... That helped me out. I was having problems getting the code
assigned to the button. But I figured that out. After that it was
simply adding the correct code.



On Thu, 13 Jan 2005 22:24:03 -0500, "Paul B"
<to_much_spam_to_list@nospam.com> wrote:

>Richard, check out Ron's site for a LOT of information on this
>
>http://www.rondebruin.nl/sendmail.htm#Workbook.