Microsoft outlook forms and rules wizard

[Ade Sinclair]

Hi,
I have created an outlook form allowing staff in another department to
contact our admin team requesting certain documents be sent to our customers.
The form uses tabs and drop down options to choose various documents. The
heading is the same "mailbox request". The form works well however the admin
team are receiving hundreds of requests and have asked if outlook can be set
up to split the requests into separate folders for each document (ie booklet
folder contacins all requests for booklets etc). I tried using the rules
wizard but for some reason it wont recognise the content of the forms and as
the heading is the same (mailbox request) we cant seem to split the requests
into separate folders.

Can you help? We simply want to check each form as it comes in to the admin
department and then move it to a folder for that work type. Alternatively,
is there a way of having a drop down option to change the name of the subject
heading - that way we could filter using the wizard on the subject.

 

[Sue Mosher [MVP-Outlook]]

Is there a single custom property on the form that distinguishes the type of document being requested? Is this form published to the Organizational Forms library?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Ade Sinclair]

the form is published in the organisational forms library (tools, forms,
choose a form). The form itself has a series of tabs with headings such as
"reprint", "file retrieval" (there are 8 tabs in total) - with each tab
containing its own properties.

If it was possible to identify if any of the tabs contained completed fields
this would help greatly...

 

[Sue Mosher [MVP-Outlook]]

You'll probably get more mileage -- and certainly more flexibility -- from the Rules Wizard in this scenaro if you use a "run a script" rule to fire a VBA procedure that processes the item. A "run a script" rule action takes a MailItem or MeetingItem as its parameter, then uses that item in the code:

Sub RunAScriptRuleRoutine(MyMail As MailItem)
Dim strID As String
Dim olNS As Outlook.NameSpace
Dim olMail As Outlook.MailItem

strID = MyMail.EntryID
Set olNS = Application.GetNamespace("MAPI")
Set olMail = olNS.GetItemFromID(strID)
' do stuff with olMail, e.g.
MsgBox olMail.UserProperties("Your First Custom FIeld")

Set olMail = Nothing
Set olNS = Nothing
End Sub



--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Ade Sinclair]

excellent!

thanks for this. I figured I'd need to use a bit of VB code
somewhere...I'll get one of our VB'ers to have a look at it.

Many thanks

Ade