Creating While Loops in SharePoint Designer Workflows using Stateful Workflows
For an update on this topic please see this blog entry: https://nickgrattan.wordpress.com/2010/12/14/while-loops-in-sharepoint-designer-workflows/
Amongst several significant limitations with SharePoint Designer workflows, perhaps the most important is the lack of looping. Therefore, expressing processes like “while not approved, rework” becomes difficult.
We have published a paper that describes how to implement while loops by emulating stateful workflows in Microsoft SharePoint Designer. You can download the paper here (PDF, Oct 2009). The technique uses our “Restart this workflow” custom action, which is part of our “Custom Activity Pack”
which can be downloaded here for free.
Update: 10-Nov-2013. Source code and WSP now available in GitHub: https://github.com/NickGrattan/NGCCustomActivities.git