i have a small workflow requirement that seems complex to me.
I have a custom list where in i want to send daily reminder mails to each user whose list item status is pending.
Now what i want the workflow to do is to run every day at 9:00 A.M and send a auto mail to users whose activity have status Pending.
Then, to send another reminder mail at 4:00 P.M the same day for the activites whose status is Pending.
Now, at 6:00 P.M, i want the auto mail to trigger for those activities whose status is Pending and send a mail to users manager.(Like an escalation mail).
if the activity status has been set to completed by user, the auto mail sends a notification to usres manager saying the activity has been completed .
Note: i want the workflow to run every day and to check for items which are pending.
Also, i want a bulk email for all those activity to users which are pending and not a single email as this would make user annoyed.