Outlook GAL to table possible? (Access and Outlook 2003)

[PK]

Is it possible to extract information from the GAL in Outlook 2003 to a table
in Access 2003?

I am interested in getting NAME (Display), SMTP, ALIAS

tx

 

[Arvin Meyer [MVP]]

You can either export from Outlook, or import from Access.

 

[Danny Seager]

right click on the tables window and select link tables, then select in the
"Files of Type" Exchange, then you can link the GAL from there

 

[PK]

Wow, Danny - that is GREAT! I am getting everything i need except the SMTP
address - any suggestions?

 

[pietlinden]

Is it possible to extract information from the GAL in Outlook 2003 to a table
in Access 2003?

I am interested in getting NAME (Display), SMTP, ALIAS

tx

I am pretty sure you can connect to it since the GAL is available in
Outlook.
File, Get External Data,... then change the type to Exchange and it
should be pretty easy from there. Then you should be able to query
the GAL as if it were a local Access table.

 

[PK]

The SMTP address isnt a field in the linked table... (Display name and Alias
are, along with several other fields like address tel num etc...)

Any ideas?