Steve Capistrant
scapistrant at symphonyinfo.com
Thu Apr 17 09:42:18 CDT 2003
Drew, 1. A PAB issue is puzzling me. My version of Outlook (2000 SP-3) doesn't' provide anyway to specify different ways to store contacts (personal address book vs. public, etc). I remember having this capacity some time in the past, but don't know why not now. No PAB files exist anywhere on my C: drive. 2. Thanks for the tip about Addins; I'm looking for an Access 2000 version, so will do some exploring on MS. 3. Other responders have clued me in to how to push contact/email data from Access to Outlook, but it is not clear what happens if this is done repeatedly (e.g. once a day with the intent of one-way synchronization). Does Jane Doe keep getting more records added, or does Jane Doe's record get overwritten? If the latter, is it based on an exact match of some fields? Or must my code first wipe out all contacts in the target location before pushing a new export of data? 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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Drew Wutka Sent: Tuesday, April 15, 2003 7:47 PM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Pushing to Outlook A few things. First, you can have the users put personal contacts into their Personal Address Book (.pab files). Next, there are two ways to manipulate Outlook Contacts...one is through MAPI (or CDO), which isn't that tough, but it does require a bit of coding... The other, and I am not sure if it let's you write back to the source, but there are Add-ins for Access which let you 'link' tables to Exchange and PST files. They are available from Microsoft. Which version of Access are you using, I have the Add-in for 97. Drew -----Original Message----- From: Steve Capistrant [mailto:scapistrant at symphonyinfo.com] Sent: Monday, April 14, 2003 2:14 PM 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 ______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com