user-defined error with Dim olApp As Outlook.Application

I get the above error from line :

Dim OlApp As Outlook.Application

I'm using Acess 2007 so don't see how I navigate to check Microsoft Access 11.0 Object Library ref is ticked.  I've seen in similar answers that you go to  Tools/references  but; this isn't there in access 2007 so how do I do this.

I tried adding an activex control for microsoft office outlook command button control to see if this was the equivalent but; won't let me do this.

Any suggestions would be apreciated.
Who is Participating?
Bob LearnedConnect With a Mentor Commented:
1) Access 2007 is Access 2.0, which is on the COM tab

2) You are trying to create an Outlook application instance.
ellizzAuthor Commented:
I have now got passed that error by using late binding but; now when run the code get automation error, the specified module could not be found
Does anyone know what this means and how to fix it?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.