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

[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

 

[Douglas J. Steele]

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