email Button

[BadRasta!]

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 (e-mail address removed)
Button 2 pressed send current worksheet to address (e-mail address removed)

& so on

Thnx,
BadRasta

 

[Reitanos]

You could use a macro with the following line:
ActiveWorkbook.SendMail Recipients:="(e-mail address removed)"

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?

 

[Ron de Bruin]

Hi BadRasta

See this page
http://www.rondebruin.nl/sendmail.htm

 

[Jasfoster]

Is there a way to record the Macro with a line just to send a single sheet
not the entire workbook?