Some way to capture who marks an email as read

[Mikeymon-scot]

I I run a service desk and we have a large number of mailboxes. Generally the
guys work along the lines - if a mail is unread it is to be actioned - if
it's read someone is doing it. I have an issue where there is a small number
of peope who mark emails as read but do nothing with them. What I'd like to
be able to do is get some kind of vb that i can use to keep track of who is
marking what as read. I can't use read recpiepts as the mails come from a
large number of internal and exteral sources. I'm pretty comforable with vb
in excel but know little about outlook. If someone could give me some ideas /
pointers on how I could do this / is it possible or even a little code to
start me off I could probably go from there.

If required, which I'm guessing it probably would be, I could have each of
the guys import any code and save it as a VBA project in thier own outlook
sessions.

Thanks in advance

 

[Ken Slovak - [MVP - Outlook]]

Distributing a VBA macro isn't really an optimal way to deploy code, a COM
addin is much better. See http://www.outlookcode.com/article.aspx?id=28 for
an explanation.

The PR_LAST_MODIFIER_NAME (0x3FFA001E) property isn't exposed in the Outlook
object model at all. For Outlook 2007 you can get the mail item's
PropertyAccessor object and use the DASL property tag (a string tag, not a
URL): "http://schemas.microsoft.com/mapi/proptag/0x3FFA001E" to get who last
modified an item. That doesn't tell you who marked it as read, unless that
was the last modification done on the item. Who marked something as read is
not stored as a value at all.

For versions of Outlook earlier than 2007 you would have to use a lower
level API to access that property, such as CDO 1.21 or Redemption
(www.dimastr.com/redemption).

For general information on programming Outlook look at www.outlookcode.com