Email sheet using a macro

[christopher_hart]

HI

i am trying to get excel to email a sheet to a certain address. I have managed to do this, however when i try and record a macro to perform this task, it doesn't work. Could any one help in providing a code for me to do this.

Basically all i want to do is send a copy of a filled in sheet to an e-mail address by just pressing a button.

Thanks for any help

Christopher Hart

 

[arnoldmiranda]

How can you add multiple recipients to this macro

 

[Jonnyk61]

How can you add multiple recipients to this macro

Just add 'Array', as shown below.

Private Sub CommandButton1_Click()

ActiveWorkbook.SendMail Recipients:= Array ("RECIPIENTS E-MAIL", "An other RECIPIENTS E-MAIL"), Subject:="Goes Here", ReturnReceipt:=True
MsgBox "Your Request Has Been Sent", , "Title Goes Here"



End Sub

 

[pankaj2610]

Just add 'Array', as shown below.

Private Sub CommandButton1_Click()

ActiveWorkbook.SendMail Recipients:= Array ("RECIPIENTS E-MAIL", "An other RECIPIENTS E-MAIL"), Subject:="Goes Here", ReturnReceipt:=True
MsgBox "Your Request Has Been Sent", , "Title Goes Here"



End Sub

How it can be work to send a single worksheet