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 "[email protected]"
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, 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" <[email protected]> wrote in message
news:[email protected]...
> 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 "[email protected]"
> 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

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"
<[email protected]> wrote:

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