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.

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?

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

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's avatar
    jcastr02
    Icon for Post Prodigy rankPost Prodigy
    3 years ago

    I see it now, thanks ChrisMendoza for your help.

  • CMSandu's avatar
    CMSandu
    Frequent Visitor
    2 years ago

    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's avatar
      ChrisMendoza
      Icon for Resident Rockstar rankResident Rockstar
      2 years ago

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

      • CMSandu's avatar
        CMSandu
        Frequent Visitor
        2 years ago

        Thank you so much! I will give it a try