Wortz, Charles
CWortz at tea.state.tx.us
Mon Apr 14 14:18:14 CDT 2003
Steve, Helen Feddema has a code sample at her site http://www.helenfeddema.com/CodeSamples.htm that should do what you want. Scroll down to the Access to Outlook section. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: Steve Capistrant [mailto:scapistrant at symphonyinfo.com] Sent: Monday 2003 Apr 14 14:14 To: accessd at databaseadvisors.com Subject: [AccessD] Pushing to Outlook Hi folks. Looking for tips on how to push contact info from Access into Outlook. What are the main elements in the Outlook object model that let me add and delete contact items from VBA in Access? (I don't currently need the ability to edit existing items -- too messy to think about for Monday). The bottom line task: delete all existing contact info from Outlook and repopulate with the fresh info from an Access db. But, the user also needs to have a way to independently manage their PERSONAL contacts without getting overwritten. Separate pst files, I imagine? Thank you.... Steve Capistrant Symphony Information Services 212 3rd Avenue North Minneapolis, MN 55401 www.symphonyinfo.com Phone: 612-333-1311 Fax: 612-333-5572 Email: scapistrant at symphonyinfo.com