Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sharepoint query to send mail until it gets hundred percentage

share|improve this question

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.

2  
Please explain your question in a more concise and clarified manner. –  Arko D May 31 '12 at 12:18
    
We need more information to answer your question. Please edit your post and add details as requested by the community. It will be closed for now, but don't worry - once you have improved the question flag a moderator and it can be reopened. See our FAQ for general guidelines. –  SPDoctor Jun 1 '12 at 12:31
    
Please explain your question with more details if you think we know your default setting and pages you designed and your desired and ... please describe more to help you –  saber tabatabaee yazdi Jan 18 '13 at 8:39

1 Answer 1

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.

share|improve this answer
    
Hi Danny,thanks a lot for your immediate reply. I will explain it in a simple manner. Say i have two columns called "due date" and "percentage". Mail should trigger every day after due date, until percentage gets 100%. If it is not possible in designer can you provide me the code(VS 2010). –  Ramanjulu Jun 1 '12 at 13:22

Not the answer you're looking for? Browse other questions tagged or ask your own question.