Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Mail Enabled Public Folder (http://www.outlookbanter.com/outlook-vba/72784-mail-enabled-public-folder.html)

[email protected] May 29th 08 05:52 PM

Mail Enabled Public Folder
 
Hello everyone,

I am running server 2003 enterprise x64 with exchange 2007. I setup
couple of public folders and i have a general email address routing
mail to public folders based on outlook rules that i have created.
There are a few moderators for each PF.

Here is the scenario: User A checks PF-1 and see's a new email, he
deals with that email. 5 minutes later User B checks PF-1 and notices
an email there, but has no idea if it was dealt with or not.

I am looking at changing the view in the PF and add a field that shows
exactly who opened it. This way an email comes in its marked unread
until someone opens it, under the View field (ex. Opened By) displays
the username of the person who opened the message.

Has anyone does this before or can anyone point me in the right
direction of what needs to be done.

Thank you in advance for all your help.

Jason

Michael Bauer [MVP - Outlook] May 30th 08 06:12 AM

Mail Enabled Public Folder
 


Maybe VBScript behind the form is an option, which you have to publish then
so that every user uses it:

Function Item_Open()
Dim UserProps
Dim Prop
Set UserProps=Item.UserProperties
If UserProps("OpenedBy") Is Nothing Then
Set Prop=UserProps.Add("OpenedBy", 1)
Else
Set Prop=UserProps("OpenedBy")
End If
If Len(Prop.Value)=0 Then
Prop.Value=Item.Session.CurrentUser.Name
Item.Save
End If
End Function


--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool:
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Thu, 29 May 2008 09:52:07 -0700 (PDT) schrieb :

Hello everyone,

I am running server 2003 enterprise x64 with exchange 2007. I setup
couple of public folders and i have a general email address routing
mail to public folders based on outlook rules that i have created.
There are a few moderators for each PF.

Here is the scenario: User A checks PF-1 and see's a new email, he
deals with that email. 5 minutes later User B checks PF-1 and notices
an email there, but has no idea if it was dealt with or not.

I am looking at changing the view in the PF and add a field that shows
exactly who opened it. This way an email comes in its marked unread
until someone opens it, under the View field (ex. Opened By) displays
the username of the person who opened the message.

Has anyone does this before or can anyone point me in the right
direction of what needs to be done.

Thank you in advance for all your help.

Jason



All times are GMT +1. The time now is 06:44 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com