e-mail the current worksheet using a form button

[Richard Smack]

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 "(e-mail address removed)"
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 B]

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]

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.