[AccessD] Outlook Mail Item relationship between ConversationID and ConversationIndex

[Jim Lawrence]

I have always thought the Microsoft's Outlook is a sort of "after thought" product...there just to fill out the product line and provide access to their flag ship Exchange. IMHO, this is why Outlook is always such a bear to automate and filled with security holes...it needs more love.

Jim

----- Original Message -----
From: "Susan Harkins" <ssharkins at gmail.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Sunday, November 4, 2018 10:34:20 AM
Subject: Re: [AccessD] Outlook Mail Item relationship between ConversationID and ConversationIndex

Interesting -- this might help -- I wouldn't have know it, but it makes
sense that ConversationID would be local: 

<https://docs.microsoft.com/en-us/office/client-developer/outlook/mapi/track
ing-conversations>

Susan H. 


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

 

 

--
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