Make new Outlook Contacts, Update existing Outlook contacts via packaged program

  • Thread starter prairiewind via
  • Start date


prairiewind via

I need to be able to send my database (contact information) to several users
in various parts of the country. What I'm looking at is if I can package
just my "PersonInformation" table and have a command button on a form that
the user would click. This would 1) update existing contacts (I already have
a unique ID set up that would be the link between the old and new) if the
contact exists, 2) create a contact if it doesn't exist, 3) delete a contact
as needed.

I wouldn't need to compare the Outlook contact with the information to import
as I could just overwrite the necessary fields (Name, Addresses, Phones).
The users on their own machine add other notes, emails, etc. that I don't
want to overwrite.

I've found a few threads about things on one owns machine or LAN, but never
as a published package.

I am using Access 2007, Outlook 2007, Windows XP.




prairiewind via

A couple of follow up things to clarify the original post. I didn't leave it
real clear, but I would like to be able to update the Outlook contacts.

I would like to do this all with VBA.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question