[AccessD] Pushing to Outlook

Drew Wutka DWUTKA at marlow.com
Thu Apr 17 17:08:57 CDT 2003


In Outlook, click Tools, then Services.  Then 'add' a service.  One of the
services you can add is 'Personal Address Book', which will prompt you where
you want to save the .pab file.

Drew

-----Original Message-----
From: Steve Capistrant [mailto:scapistrant at symphonyinfo.com]
Sent: Thursday, April 17, 2003 9:42 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Pushing to Outlook


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


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list