how to send e-mail from excel

[Barmaley]

I need to be able to click on the button in Excel workbook resulting e-mail
sent with address and subject line are filled up
and attach active workbook to e-mail. after that e-mail is sent without any
other action. (in another scenario client will need to click Send button)

Your help is greatly appretiated

 

[steve]

Barmaley,

Go to this site and learn all about email
http://www.rondebruin.nl/sendmail.htm

 

[Don Guillett]

http://www.rondebruin.nl/

 

[Ron de Bruin]

Use this then

Sub test()
On Error Resume Next
ActiveWorkbook.SendMail "(e-mail address removed)", _
"This is the Subject line"
On Error GoTo 0
End Sub