debugging with e-maill through access

[eyalco]

I'm trying to run e-mail messages from access but it stops on debugging on that line in my code :

"Dim objOL As New Outlook.Application"

What is wrong pls?

 

[chergh]

Have you included the Microsoft Outlook object library in your references?

 

[eyalco]

Have you included the Microsoft Outlook object library in your references?

Not sure I know how.
Here's what I wrote there :

Private Sub send_Click()
On Error GoTo Err_send_Click
Dim Dbs As Database
Dim Rst As Recordset
Dim objOL As New Outlook.Application
Dim objMail As MailItem
Dim body1 As Variant
Dim DistributeList, STR As Variant

anythin missing?

 

[chergh]

Yes go to the tools menu and select references and check the reference for "Microsoft Outlook Object Library"