Outlook data - Reply to an email

[jcastr02]

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 a date of (if we replied on it).  I tried to look by id column but didn't find any relationship between the emails.  Any other thoughts?

[ChrisMendoza]

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

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

[ChrisMendoza]

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

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?

[ChrisMendoza]

@jcastr02 - I don't understand what you mean? In this sample, the incoming mail was sent 3/25 and the reply was 3/27. 

[jcastr02 · Accepted solution]

I see it now, thanks @ChrisMendoza for your help.