Add recipients to Outlook through VBA code

[finaljustice]

Hi,
I've created a code to make a routine and then send an email of the worksheet. The part that is new to me is the sending e-mail using VBA, so I decided to record the action and then adapt to what I need. From what i recorded I basically got this:

Sub e-mail ()
                                                     
Sheets(1).Copy


Application.Dialogs(xlDialogSendMail).Show
    
End Sub

"Application.Dialogs(xlDialogSendMail).Show" opens an e-mail message to be sent, requiring manual input of the recipients, I would like to automate even this part so that I can just message a "E-mail was sent" notification.

Could anyone help me in how do I code the adding TO: list and make it send?

Thanks for your attention

final

 

[hippiehacker]

Hi,
I've created a code to make a routine and then send an email of the worksheet. The part that is new to me is the sending e-mail using VBA, so I decided to record the action and then adapt to what I need. From what i recorded I basically got this:

Sub e-mail ()
                                                     
Sheets(1).Copy


Application.Dialogs(xlDialogSendMail).Show
    
End Sub

"Application.Dialogs(xlDialogSendMail).Show" opens an e-mail message to be sent, requiring manual input of the recipients, I would like to automate even this part so that I can just message a "E-mail was sent" notification.

Could anyone help me in how do I code the adding TO: list and make it send?

Thanks for your attention

final

this site should get you started

http://www.rondebruin.nl/sendmail.htm

 

[finaljustice]

this site should get you started

http://www.rondebruin.nl/sendmail.htm

Wow cool! thanks that was really helpfull!
Cheers!