D
Dave Lett
Hi all,
I've been asked to develop a new database of company contacts (approximately
100 users). Instead of recreating the wheel, I was hoping that I would be
able to export the contact information from each user's Outlook Contacts.
Here's the basic scenario
Each person uses Outlook (however, we are not on a single version).
Some people have customized their categories, which would be important to
export/import, too.
The Contact database is to be updated every two weeks (at a minimum).
Questions:
1) Can/how would I export each person's contact to a single database that 1)
appended nonduplicated records and 2) replaced old records with updated
records (avoid duplicating records)?
2) Because no user is very technically adept, can/how would I create a
routine (using VBA, for example) that I can install company wide to simplify
their task (i.e., is it possible to create a button that they could press to
export their contact information as described in number 1 above)?
I have excellent VBA skills with Word, passing VBA skills with Excel, and
virtually none with Outlook. I'm comfortable enough with VBA's object model
that I can figure a lot of this stuff out for myself, but I really need a
direction on this project. I'm hoping that I can do this with VBA so that I
can avoid having this turn into a mundane, repetitive task.
Thanks in advance.
Dave
I've been asked to develop a new database of company contacts (approximately
100 users). Instead of recreating the wheel, I was hoping that I would be
able to export the contact information from each user's Outlook Contacts.
Here's the basic scenario
Each person uses Outlook (however, we are not on a single version).
Some people have customized their categories, which would be important to
export/import, too.
The Contact database is to be updated every two weeks (at a minimum).
Questions:
1) Can/how would I export each person's contact to a single database that 1)
appended nonduplicated records and 2) replaced old records with updated
records (avoid duplicating records)?
2) Because no user is very technically adept, can/how would I create a
routine (using VBA, for example) that I can install company wide to simplify
their task (i.e., is it possible to create a button that they could press to
export their contact information as described in number 1 above)?
I have excellent VBA skills with Word, passing VBA skills with Excel, and
virtually none with Outlook. I'm comfortable enough with VBA's object model
that I can figure a lot of this stuff out for myself, but I really need a
direction on this project. I'm hoping that I can do this with VBA so that I
can avoid having this turn into a mundane, repetitive task.
Thanks in advance.
Dave