In our Student Administration database we would like to link to the Outlook contacts of one (and perhaps other) of our users.
I’ve seen in Outlook how a Contacts folder can be shared so that one user can see another’s contacts folder in addition to their own. When attempting in Access to use the External Data, More, Outlook Folder wizard, I first had to set up/configure Outlook on my computer. However, it seems the Wizard only looks on my PC for these and so I am unsure how to link to another user’s Outlook contacts. It did create a linked table to my outlook contacts. Perhaps it requires that you already have shared access to the other person's contacts in Outlook...?
I found one seemingly relevant thread in the Access forum entitled “Importation contacts Oulook depuis Access 2010”. The problem here seemed to be that a macro to automatically add a contact from Outlook stopped working when the database was split. The suggested possible solution was “…. a temp table in the front end to hold the imported contact record then use an APPEND SELECT action to transfer into the linked backend table.” I did not see anything else in your Import/Export forum or on other Access or Outlook forums that seemed helpful.
So, my questions are:
- How can my Access database link to another person’s Outlook contacts?
- How would I integrate or sync that linked table with another Contacts table in the Access database?
Note: while the ability to sync both ways between Access and Outlook is desirable, it may only be necessary to be able to post Outlook updates to Access.
As always, thanks for any guidance.