email Button

B

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 [email protected]
Button 2 pressed send current worksheet to address [email protected]

& so on

Thnx,
BadRasta
 
R

Reitanos

You could use a macro with the following line:
ActiveWorkbook.SendMail Recipients:="[email protected]"

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

Jasfoster

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