Importing Names From Outlook() Using VBA

[PC User]

I tried to use the Access Help to figure out the import command, but I need help to get it to work.
Code:
--------------------------------------------------------------------------------
DoCmd.TransferText acImportDelim, , "Global Address List", "Outlook()", -1
--------------------------------------------------------------------------------

Thanks,
PC

 

[dt01pqt]

No, this is not the way to go. You can import or link tables using Exchange/Outlook Wizard or create an instance outlook through ActiveX. I have provided an example in the code repository to use a contact name from an address box and with this retrieve the actual email address of the particular contact. However if you don't have a complicated arrangement in terms of contacts folders this is not necessary because Outlook will recognise the contact in most cases.

 

[PC User]

Actually I need more than the names from the Outlook() Global Address List (GAL). I also use several levels of the company's organization to insert into the records. The GAL also has the user id's that I use for the audit tracking table. I get the impression that the GAL is different from the Contacts List; so I was hoping to find code to update the GAL table in my database by clicking on a button. Otherwise, I'll have to continue to manually update the table, because linking to Outlook() slows down my program significantly.

Thanks,
PC

 

[dt01pqt]

You can update your tables programatically, but why bother when they can be linked. The Global Address Book contains the full list of contacts available in all the contacts folders.

 

[PC User]

... linking to Outlook() slows down my program significantly.

 

[tkpstock]

Linking to Exchange()

When I create a Linked Table to the Exchange() GAL, bringing the table up is EXTREMELY slow. It takes close to 30 seconds just to populate the 30 or so records on the screen, then if I scroll down a record, it must re-populate the entire list.

Anyone know a way around this?

I should say that currently I have a local copy of the GAL that I hit on - the user must update this table manually every now and then. The function I created copies records out of the GAL and inserts the data into a local table, but this still takes close to 30 minutes.