Outlook contacts in Access Database

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

Guest

Does anyone know how to link outlook contacts in a useable way to an access
database? I have been able to link them, but can not associate the data well
in access because I can't create a "key" field without creating it in one of
the premade outlook user fields and then manally entering a contact reference
number for each of my contacts. I can not use any of the contact "name"
fields because we have many Mary Smith's, etc.

Please help.
 
The linked table method has major limitations, including the inability to show even all the reasonably important fields. While articles have been written on how to expand on this method's obvious features, I've never been able to duplicate the results. See http://www.outlookcode.com/d/database.htm#linkedtables .

That page will also give you other ideas on how to work with databases and Outlook together. To accomplish what you want (which you haven't revealed yet), you may need to write code or use a third-party tool that does the heavy lifting.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Yes, I do not know either, but I could give you a hint. You could of course
create a link table out of your Outlook Contacts folder. Maybe you did so.
Anyway I did. I then found that a certain amount of contact items did not
appear in the linked table. I also found that the "Display as" field was the
key field for the table. Thus no contact without an email address was present
in the linked table as that field normally is created when the email address
is fed in.

This is a nuisance! Could anybody advice on how to solve this problem, i.e.
how to either change the key field designation or ... I do not want any
intermediate export/import procedure if I can avoid it as I am so darn
close...
 
The best solution might be to use a third-party tool that exposes an Access table as an Outlook contacts folder; see http://www.outlookcode.com/d/database.htm#tools

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top