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

[kentverbal]

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

 

[Sue Mosher [MVP-Outlook]]

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.