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

  • Thread starter Thread starter James
  • Start date Start date
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
 
Is your database in a Trusted Location? Unless it is, Access will not run
VBA.
 
Back
Top