Forum Discussion

arhetyp's avatar
arhetyp
Helper I
7 years ago

Outlook: how to link Inbox & Sent Items

Hi,   I need to calculate turnover time from mail receipt to mail response. My issues is: how to link message from Inbox folder with the relevant message that was an answer?   Which parameters m...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Arek,

 

Yes, the two fields in the snapshot, Attributes.References and Attributes.InternetMessageID, connect each other accurately. Please give it a try.

Outlook_how_to_link_Inbox_Sent_Items2

 

 

 

Best Regards,

Dale

arhetyp's avatar
arhetyp
Helper I
7 years ago

Hmm...

I am afraid I did not get it:)

Can you please present how to unique key should look like?

 

Cheers,

Arek

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Arek,

     

    Which email domain do you have? Maybe it has different properties with mine. Please have a look at the column titles. We can expand the attributes to get the result.

    how_to_link_Inbox_Sent_Items

     

    Best Regards,

    Dale

    • arhetyp's avatar
      arhetyp
      Helper I
      7 years ago

      Hi Dale,

       

      attributes are the same, at least here we are at the same page:)

      Please let me to explain step by step what is my way of working:

       

      1. 2 tables imported from Exchange - Inbox and relevant Sent Items shared mailboxes.

      2. Then I need to assign to each mail from Inbox related Sent date - what I mean by that is to get the date/time when particular mail was actually answered.

      3. To make step 2 happen I need to find a 1:1 relation between those two tables:

       

       

      4. According to your proposal  I created a similar key in both tables:

       

       

       

      5. I am afraid this combinations does not ensure us a unique key:

      Am I doing sth incorrectly?

       

      Regards,

      Arek

      • arhetyp's avatar
        arhetyp
        Helper I
        7 years ago

        Hi:)

         

        can Dale or anyone advise with that issue?:)

         

        Regards,

        Arek