Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote -4 down vote favorite

Sharepoint query to send mail until it gets hundred percentage

share|improve this 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 at 8:39

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, see the FAQ.

1 Answer

up vote 1 down vote

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.