how to send e-mail from excel

  • Thread starter Thread starter Barmaley
  • Start date Start date
B

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending e-mails from specific email address 2
Prevent Sending eMail from Excel 3
Attach file to e-mail using excel macro 2
Excel to e-mail, with a twist 1
E-mailing from Excel Q 13
Sending Excel Workbooks to Outlook people automatically 1
Sending e-mail with Excel 1
Excel Macros sending attachments to multiple e-mail addressescontained in one cell. 4

Back
Top