Importing Outlook Contacts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good morning
I have several hundred Outlook Contacts. Unfortunately, they are all in different folders which aren't visible to Access's import function. Although, I am not sure why. Is there a way to import these contacts into one whopping table? From there, I can break it down between Contact Info and Company Information.

I've even tried viewing the Contacts as an address book in Outlook, but it won't show up there for my purpose of importing

I'm in 2000 for both applications AND Windows 2000 system

Thank you
Derek
 
Hi Derek,

Some suggestions:

-Copy or move all the contacts into a folder that Access can see.

-Export the contents of each folder to a text (CSV) file and import
these into your Access table.

-It's also possible to write VBA code that uses the Outlook object model
to retrieve the information from each folder in turn.
 
Back
Top