We are having a bit of an issue with our contact information at my office. Currently we have a proprietary system that was built in house to deal with our contacts and stakeholders. Before that was created, we had about 1400 entries put onto our Exchange 2003 server's public contacts. We have SINCE started using a third-party COTS CRM, that only limited people have access to because of the cost associated with user accounts.
Our client services people maintain the most current customer information on the third party piece of software, which we then export to an .mdb file (the proprietary system is built on MS Access 2003). The .mdb file is then imported to our local system where all the staff have access.
With that said, we have 2 copies of a CURRENT database. One on the outsourced (third party) server, and one on our local system... then comes the public contacts. We have a few users that use the Public Contacts frequently (most specifically distribution lists). We have a very complicated business line where e-mails are sent to only certain stakeholders based on which services of ours they subscribe to. With a few people, this is done with distribution lists in public contacts. This needs to be manually updated, and as such is quite a time-intensive task.
I'm wondering if there is an easy way to import information from the .mdb file that we export from our TP CRM and import onto our system into public contacts.
I know that you can import .csv's into Outlook then copy over to Public Contacts, but the fact that you can't import distribution lists is a big obstacle.
If anyone knows a way to get around this I would be quite appreciative.