Access 2007 calls to Outlook 2007, Won't 2007 take VBA calls?

J

James

I have a VBA module that calls an Outlook Object, When run with MS
Office 2007 I get an undefined variable error. Is MS 2007 deaf to
VBA? The error occurs in the first line of the following code:

Option Compare Database
Option Explicit

' InitOutlook sets up ola and nsp.
Private ola As Outlook.Application ----< Here with ola
Private nsp As Outlook.NameSpace

Can't get any response from MS
 
D

Douglas J. Steele

Is your database in a Trusted Location? Unless it is, Access will not run
VBA.
 

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

e-mail from access 0
Outlook 2013 keep crashing with MSVCR100.dll 1
Need to Override Outlook 2007's security 1
Redemption and Outlook 2007 8
Send Email with Access 2007 2
Outlook 2007 Won't Start 7
VBA Compile error when converting to Access 2007 4
Outlook 2007 won't connect to Exchange 2007 0

Top