email Button

  • Thread starter Thread starter BadRasta!
  • Start date Start date
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 (e-mail address removed)
Button 2 pressed send current worksheet to address (e-mail address removed)

& so on

Thnx,
BadRasta
 
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?
 
Is there a way to record the Macro with a line just to send a single sheet
not the entire workbook?
 
Back
Top