Some way to capture who marks an email as read

[TWlrZXltb24tc2NvdA]

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

"Mikeymon-scot" <Mikeymon-scot> wrote in message

news:3FD9DDB0-1535-4AB2-A2D7-86EC54D10D32@microsoft.com...
> 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