sammus:... is there a way to execute it
always, i mean every day it should check whether documents duedate has
reached if it has, then should send an email..is it possible to execute
a workflow like that??
I think you could accomplish this using several options:
One - You can do this with state machine workflow, a state with DelayActivity in it that would wake up regularly and do your check, and a simple SendEmail activity to send email. This would need to be done using Visual Studio, though.
Two - You could use the action "Pause Until Date" in SPD. You start the
workflow on new item creation, and do something like the following.
ACTION: [Pause Until Date] Pause until Tasks:Due Date
ACTION: [Send and Email] then Email this message
This starts the workflow, pauses until your Due Date is reached, and
then sends off a reminder email. It's simple, but it may be all you
need in your scenario. There is no reason to continually check state if you don't have to. You know what I mean?
-Monjo