You could use a macro with the following line:
ActiveWorkbook.SendMail "

Excel will attempt to send it using the default mail client (if there
is one) and give the message a subject that is the document name.
You could create the button with the Forms toolbar and assign your
macro to it.

There's probably a way to force a custom subject line - anyone know?

On May 9, 12:40 pm, BadRasta!
wrote:
Hello All,
I'm trying to create a button that when pressed it sends an email to a
specific email address.
That is...
Button 1 pressed send current worksheet to address
Button 2 pressed send current worksheet to address

& so on

Thnx,
BadRasta