Determining resposne time to incoming messages

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)

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

--
Viele GrĂĽĂźe
Michael Bauer


"Nir N" <Nir N@discussions.microsoft.com> wrote in message
news:5ACBC495-BC6D-4021-8FF4-85F4A4EB70E1@microsoft.com...
> 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 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
>-----Original Message-----
>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)
>
>If that matters then I don´t know the answer...
>
>--
>Viele GrĂĽĂYe
>Michael Bauer
>
>
>"Nir N" <Nir N@discussions.microsoft.com> wrote in
message
>news:5ACBC495-BC6D-4021-8FF4-
85F4A4EB70E1@microsoft.com...
>> 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
>
>.
>

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

--
Viele Grüße
Michael Bauer


<anonymous@discussions.microsoft.com> wrote in message
news:4e7d01c52261$121eaee0$a401280a@phx.gbl...
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
>-----Original Message-----
>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)
>
>If that matters then I don´t know the answer...
>
>--
>Viele GrĂĽĂYe
>Michael Bauer
>
>
>"Nir N" <Nir N@discussions.microsoft.com> wrote in
message
>news:5ACBC495-BC6D-4021-8FF4-
85F4A4EB70E1@microsoft.com...
>> 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 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
>-----Original Message-----
>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)
>
>If that matters then I don´t know the answer...
>
>--
>Viele GrĂĽĂYe
>Michael Bauer
>
>
>"Nir N" <Nir N@discussions.microsoft.com> wrote in
message
>news:5ACBC495-BC6D-4021-8FF4-
85F4A4EB70E1@microsoft.com...
>> 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,

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

--
Viele Grüße
Michael Bauer


"Nir" <anonymous@discussions.microsoft.com> wrote in message
news:500501c5229f$1e797d30$a401280a@phx.gbl...
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
>-----Original Message-----
>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)
>
>If that matters then I don´t know the answer...
>
>--
>Viele GrĂĽĂYe
>Michael Bauer
>
>
>"Nir N" <Nir N@discussions.microsoft.com> wrote in
message
>news:5ACBC495-BC6D-4021-8FF4-
85F4A4EB70E1@microsoft.com...
>> 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
>
>.
>

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
http://www.outlookcode.com/jumpstart.aspx


"Nir" <anonymous@discussions.microsoft.com> wrote in message
news:500501c5229f$1e797d30$a401280a@phx.gbl...
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 N" <Nir N@discussions.microsoft.com> wrote in
message
>news:5ACBC495-BC6D-4021-8FF4-
85F4A4EB70E1@microsoft.com...
>> 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
>
>.
>