|
|
I need to have my office's outlook contacts be stored in a central shared
location for all in the office and have everyone have access to view these
contacts. It's similar to using exchange but without it. The tactic I've used
is to create a database in access that links to each persons contact list in
outlook. Each person needs to export their local outlook contacts to the
shared drive and my database creates links to each of those files. I know
that if it links to the files on the physical computers it would create a
more "real-time" sync but the computers would have to be on and the data
could be lost if something happens to the local PC. This creates a "backup"
service, in case data is lost on the physical PC's and also accessibility to
everyone else's contacts if needed. Each person has their own backup access
file with only a table in it; my database resides on the same location and
links to each person's backup table file.
The problem is that I'd like to automate the exporting of contacts from
outlook to the backup access files, at lease make it a "one click" kind of
process. This is because, any changes made to the outlook files is not
reflected in the access. I'm not sure how to write the macro to do this
either from each person's outlook or from the central access database.
Any ideas?
|
|
|