Life Balance Task List

[robwoods]

- newbie
- Outlook 2003
- Custom task form

No answers to my previous questions, so I'll try asking differently.

I'm trying to create a task list that sorts itself by a calculate
priority. the priority is a function of task effort and importance.
It is also a function of the current time, due date and lead time. S
if you are close to the due date, the priority will increase. It'
actually very helpful in prioritizing your life.

I need some help in implementing this though. I'd like to be able t
sort by priority (a "Priority Value" field maybe). However, if i mad
the field a Formula field, I cannot sort on it. But if I make it
normal value field that is bound to a calculation based on the abov
inputs, it does not update as time goes on. Is there a macro tha
could be written to automatically go through every task and updat
values fields as if they were formula type fields?

An easy formula to use as an example would be: now().

Thanks for the help!!!

Ro

 

[Sue Mosher [MVP]]

Sure you can loop through all the items in a folder using a For Each loop:

For Each objItem in objFolder.Items
objItem.UserProperties("some date") = Now()
objItem.Save
Next