K
Kathy Drungilas
I've created code to automatically assign tasks to others. The assignment works well (thanks to all the help I've received from the large Outlook vba community!). I do have a problem when running the code on the folder a second, third...time for newly added tasks. (eventually, this will be run daily, but I cannot use the Item.Add procedures due to the voume of items.) The code will re-assign completed tasks which are present in the folder.
I tried a Restrict filter to return only tasks not delegated, but because some can be in an "unknown" state, that did not work. I also tried a Restrict filter on tasks that were owned by me (olOwnTask = 2), but apparently once a delegated task is completed, ownership could also return to me--so it was reassigned. I cannot seem to restrict or filter to items that are completed, because a task could be 25%, 50%, etc completed.
How do I only select tasks that are incomplete, owned by me and ready to be assigned????
******************
If myTask.PercentComplete = "0" And _
OlTaskOwnership.olOwnTask = True Then ??? run my code
******************
I am already using Select Case to only run code on a task not delegated.
Kathy Drungilas--
to answer via email, remove [nospam] from address
I tried a Restrict filter to return only tasks not delegated, but because some can be in an "unknown" state, that did not work. I also tried a Restrict filter on tasks that were owned by me (olOwnTask = 2), but apparently once a delegated task is completed, ownership could also return to me--so it was reassigned. I cannot seem to restrict or filter to items that are completed, because a task could be 25%, 50%, etc completed.
How do I only select tasks that are incomplete, owned by me and ready to be assigned????
******************
If myTask.PercentComplete = "0" And _
OlTaskOwnership.olOwnTask = True Then ??? run my code
******************
I am already using Select Case to only run code on a task not delegated.
Kathy Drungilas--
to answer via email, remove [nospam] from address