Determining resposne time to incoming messages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am trying to calculate the min, max and average response time to all
incoming e-mail messages for a specific date range.
Is there a way to calculte this data by VB or macro?

(if that matters, I have Exchange Server installed)

Nir
 
Hi Nir,

1) the first task would be to determine, which item is the reply on
which e-mail.

For the programmer the easiest way probably would be an extra
CommandBarButton for the response. In that Click event I would store the
original EntryID in an UserProperty.

If it would be to hard for the users to use this new reply button then
you´d need to trap all NewInspector events and search, at least by the
subject, the original message.

2) Determine when this item is being sent (not e.g. stored in the drafts
or cancelled).

In the ItemSend event you could check for the existing of your
UserProperty. If it exists get the original message and store its
received time and the send time of the reply whereever you want it to
store (and calculate the average). Also you could store a flag in the
original message, indicating that it´s answered once.
(if that matters, I have Exchange Server installed)
Click to expand...

If that matters then I don´t know the answer...
 
Hi Michael,

I thought this is a simple task.. After all, when you
click on a messasge, Outlook displays on the top
line "you replied to this messgae on XXXX-- click to find
all related messages"- which means Outlook has already
stored that XXXX somewhere!
If I could read this XXX I could compare it to the
recieved time of the original message and than run the
statistics.

Nir
 
So what do you ask for, is it just the calculation? For that you can use
the DateDiff function.

--
Viele Grüße
Michael Bauer


Hi Michael,

I thought this is a simple task.. After all, when you
click on a messasge, Outlook displays on the top
line "you replied to this messgae on XXXX-- click to find
all related messages"- which means Outlook has already
stored that XXXX somewhere!
If I could read this XXX I could compare it to the
recieved time of the original message and than run the
statistics.

Nir
 
Hi Muchael,

When you reply to a message Outlook displays in a yellow
line "You replied on XXX.Please click here to find all
related messages".
Where is this XXX stored?
That should ne the answer!

Nir
 
Hi Nir,

please take a look at the ConversationIndex and -Topic properties. But
AFAIK these properties arn´t absolutely reliable.

--
Viele Grüße
Michael Bauer


Hi Muchael,

When you reply to a message Outlook displays in a yellow
line "You replied on XXX.Please click here to find all
related messages".
Where is this XXX stored?
That should ne the answer!

Nir
 
That's the PR_LAST_VERB_EXECUTION_TIME property (0x10820040), not available
through the Outlook object model but only with CDO 1.21, Redemption,
Extended MAPI, etc.

It's not reliable, BTW, because the user can create the reply, save it, but
later discard it without sending it.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Hi Muchael,

When you reply to a message Outlook displays in a yellow
line "You replied on XXX.Please click here to find all
related messages".
Where is this XXX stored?
That should ne the answer!
 
Back
Top