Forum Discussion
Post ProdigyOutlook data - Reply to an email
I see it now, thanks ChrisMendoza for your help.
Post ProdigyChrisMendoza Thanks that helps - do you know where the actual Sent time would be captured for that email?
Resident Rockstarjcastr02 - 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
I see it now, thanks ChrisMendoza for your help.
This saved my a$h! Thank you so much for providing what Stack Overflow could not. 🙂
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).
