Export Contacts and related Journal Items from Outlook to Access (2003)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kentverbal@gmail.com - 23 Jun 2005 20:29 GMT

I am using Outlook 2003 and am trying to export my Contacts and their
related Journal items into an Access 2003 database. When I create a
Journal Entry in Outlook, I can see the related contact that the
Journal entry pertains to at the bottom of the Journal Entry form.
Also when viewing the Contacts>>Activites form in Outlook, I can see
all the Journal entries that have been created for this particular
Contact...

Now, when either importing the Contacts and Journal Entries from
Access, or exporting the Contacts and Journal Entries from Outlook, I
am not able to retrieve the referential link between the 2 items. This
essentially makes these 2 items useless as I need to be able to query
the journal items for a contact or vice versa. Is there a way to
export the reference between Contacts and Journal items to my Access
database? I have searched for ways to do this but have not seemed to
find the answer

Thanks in Advance,
Z

Reply to this Message

Sue Mosher [MVP-Outlook] - 01 Jul 2005 17:20 GMT

You'd have to write custom code to create a linking mechanism. What Outlook uses is the Links collection. Each Link points to an individual ContactItem, so you could create a table that contains the ID of the journal entry and the ID of each contact related to that journal entry.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I am using Outlook 2003 and am trying to export my Contacts and their
> related Journal items into an Access 2003 database. When I create a
[quoted text clipped - 15 lines]
> Thanks in Advance,
> Z

Reply to this Message