Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

calculate response time of email

Status
Not open for further replies.

ThinkToday

Programmer
Jun 22, 2020
1
IN
I have seen some threads of this same question in this forum all of them uses PR_LAST_VERB_EXECUTION_TIME...

What if the same message have two different reply messages In this case this PR_LAST_VERB_EXECUTION_TIME will only contain last reply messages time, we miss some data here...

Is there is any correct way to find the response time?

And in outlook they use the PR_LAST_VERB_EXECUTION_TIME to just show that 'this message was last replied at xxxxx' message
 
>'some threads'

There are only two threads that mention it, and the second is a reposting of (my) code from the first


You may note that there is a loop in that code, and note the exit statement ...

Code:
[COLOR=#729FCF]               For lp = 0 To UBound(ConArray)
                    If ConArray(lp, 4) = "IPM.Note" Then ' it is a mailitem
                        Set MsgItem = ns.GetItemFromID(ConArray(lp, 0)) 'mail item to check against
                        If Not MsgItem.Sender Is Nothing Then
                            If OriginatorID = MsgItem.Sender.ID Then
                                Clockdrift = DateDiff("s", VerbTime, MsgItem.SentOn)
                                If Clockdrift >= 0 And Clockdrift < 300 Then ' Allow for a clock drift of up to 300 seconds. This may be overgenerous
                                    Set GetReply = MsgItem
                                    [b][COLOR=blue]Exit For ' only interested in first matching reply[/color][/b]
                                End If
                            End If
                        End If
                    End If
                Next[/color]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top