Accessing Outlook from Access

[icoxy]

Hi,

I am new to vba programming and I am using Office 2003. I want to store emails on a network drive using Access. I found a useful start in these forums, but I am having problems.

The code contains the following:

Dim olApp As Outlook.Application
Dim olExp As Outlook.Explorer
Dim olSel As Outlook.Selection

I get error messages indicating the Outlook is an undefined user defined type.

Is this command format OK for Access 2003?
How do I identify Outlook as an application and access its libraries?

Thanks

 

[PHV]

You have to reference the Microsoft Outlook Object Library:
when in VBE menu Tools -> References ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[icoxy]

Thanks very much.