Forum Discussion

jcastr02's avatar
jcastr02
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Outlook data - Reply to an email

Hello I am trying to see a turn around time from when an email is received to when we reply on it.  When I pull the MS outlook exchange data, I see when the email is sent, recieved, but I do not see ...
Need Help
  • jcastr02's avatar
    jcastr02
    3 years ago

    I see it now, thanks ChrisMendoza for your help.

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
3 years ago

jcastr02 - I think you would need to duplicate the original 'Mail' table and then filter the result to ([Folder Path] = "\Sent Items\").

 

Then you can Merge both tables where you join 'Mail Sent' with 'Mail' on [Id].

  • jcastr02's avatar
    jcastr02
    Icon for Post Prodigy rankPost Prodigy
    3 years ago

    ChrisMendoza  Thanks that helps - do you know where the actual Sent time would be captured for that email?

    • ChrisMendoza's avatar
      ChrisMendoza
      Icon for Resident Rockstar rankResident Rockstar
      3 years ago

      jcastr02 - I was wrong, sorry I didn't test a little more thoroughly. This is actually not as easy as I had thought. You'll actually need to expand [Attributes] to get to [InternetMessageId]. Also in [Attributes] is [InReplyTo] which I'm sure you'll find useful. I chose this sample to show how difficult this may become:

      Here are teh queries and the join:

      • jcastr02's avatar
        jcastr02
        Icon for Post Prodigy rankPost Prodigy
        3 years ago

        Thanks ChrisMendoza it looks though as the reply email has the same sent/received date/time as the original email.  I am looking for the time the email was replied to (sent back).  Any ideas?