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 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's avatar
erichoang
New Member
1 year ago

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