[AccessD] Outlook Mail Item relationship between ConversationID and ConversationIndex

[thewaddles at sbcglobal.net]

Hello, 

 

I apologize if this is more of an Outlook question than Access, but here
goes.

 

I am trying to import Mail Items into two tables.

 

The first table needs to have a primary key based on the Conversation.

The second table needs to be related to the first so that One Conversation
has Many MailItems.

 

I have found the SearchKey to use as the primary key in the second table but
need to find a unique identifier for the first table.

 

Is there a way to relate a conversation and all related emails?

 

The fields I have available are

ConversationID

ConversationIndex

ConversationTopic

SearchKey

Subject

EntryID

ReceivedByName

RecipientsAddressEntry

Sender

SenderEmailAddress

SenderName

SentTo

CreationTime

ReceivedTime

SentOn

RecipientsCount

Body

AttachmentFile

AttachmentPath

 

Thank you,

Kevin