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

Discussion in 'Access VBA Modules' started by prairiewind via AccessMonster.com, Jun 2, 2010.

  1. 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.

    Thanks,
    Jeff
     
    prairiewind via AccessMonster.com, Jun 2, 2010
    #1
    1. Advertisements

  2. 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.

    Thanks,
    Jeff
     
    prairiewind via AccessMonster.com, Jun 2, 2010
    #2
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.