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:

[erichoang]

Thanks for the idea — it actually worked!
What I did was create a duplicated table, then in the model view, I joined Attributes.InternetMessageId (Duplicated Mail table) to Attributes.InReplyTo (First Mail table).

[CEWArre]

This saved my a$h! Thank you so much for providing what Stack Overflow could not. 🙂

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

[CMSandu]

Chris, May I please ask a question? I am trying to do the same and what I did was to geta  blank workbook, get the data from Exchange, leave only the columns I need plus those from Attributes. Did you seperate the queries? Like bringing in first the data about the sender and after created a new query and bought from Attributes onwards and after merged? Sorry for the silly question but this is my first time trying this. Thanks so much

[ChrisMendoza]

I'm pretty sure I duplicated the Mail query and then joined on [Attributes.InternetMessageId]

[CMSandu]

Thank you so much! I will give it a try

[jcastr02 · Accepted solution]

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