Hi
I am a visual basic/access beginner. I have been tasked with setting up a central contacts database for a small business. We want to be able to access distribution lists based on job numbers (easy enough) using outlook. But to do this we need a central email database that when modified, all users have their distribution lists modified. I thought it might be best to do this in access, as the business doesn't have exchange. I've figured out how to export contact lists to access and update them from a single computer, but not as a central database, nor how to automatically update anychanges in the access file to the contact list in outlook. I was thinking perhaps that when the user opens outlook that the contact database is automatically uploaded from access to update the outlook contact lists.
My question then, is how do i create a central email database in access that can be accessed by all officer computers(~10 computers). We do have a central x- drive.
Also, it seems that I cannot record the macros in outlook, whereas i can in excel and word. Any ideas on how to enable this ?
your help is appreciated. thank you.
Start Free Trial
