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

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.
Similar Threads
  1. Deece

    Adding a field to an existing table via a module

    Deece, Mar 2, 2005, in forum: Access VBA Modules
    Replies:
    1
    Views:
    144
    Alex Dybenko
    Mar 4, 2005
  2. Pendragon

    Set Primary Key on existing tbl via VBA

    Pendragon, Mar 7, 2005, in forum: Access VBA Modules
    Replies:
    1
    Views:
    121
    Brendan Reynolds
    Mar 7, 2005
  3. waynemb
    Replies:
    0
    Views:
    101
    waynemb
    Aug 23, 2005
  4. waynemb
    Replies:
    3
    Views:
    107
    Peter R. Fletcher
    Aug 26, 2005
  5. waynemb
    Replies:
    0
    Views:
    111
    waynemb
    Sep 13, 2005
  6. KingLars

    Errors while installing Packaged application

    KingLars, Sep 4, 2006, in forum: Access VBA Modules
    Replies:
    0
    Views:
    110
    KingLars
    Sep 4, 2006
  7. Robert5833

    Update existing values incrementally w/UPDATE SQL

    Robert5833, Jan 21, 2009, in forum: Access VBA Modules
    Replies:
    12
    Views:
    243
    Robert5833
    Jan 28, 2009
  8. sharontodd

    Run-time error in packaged version

    sharontodd, Nov 18, 2009, in forum: Access VBA Modules
    Replies:
    1
    Views:
    104
    Alex Dybenko
    Nov 18, 2009
Loading...