Sharepoint query to send mail until it gets hundred percentage
closed as not a real question by SPDoctor♦ Jun 1 '12 at 12:31
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.
The scenario you describe is similar enough to this article for me to recommend it: http://sharepointmagazine.net/articles/the-dog-ate-my-task-use-sharepoint-designer-to-email-daily-task-reminders
Create a SharePoint Designer workflow that fires whenever an item is created AND whenever an item is changed. In the initial step of the workflow, check if the percentage field value equals 100. If it doesn't, send an email and use a "Pause" activity that will effectively cause the workflow to run every 24 hours (or however often you need to send the emails). After the pause, update another field's value in the list (in the article, they increment a field called "EmailReminderCount," but it can be anything). This will kick off the workflow again, since you set it to run whenever an item is changed. The workflow will continue to run and send emails until the percentage equals 100.