SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How to send mail every quarter till expiry date using sharepoint 2010 designer workflow. My requirement goes like this. I have a field Expiry Date, I need to send mail to some users every quarter till it reaches the expiry date.

For Example:

Start Date :1st Jan 2013 and Expiry date is 1st jan 2015, I need to send a mail on 1st April 2013, 1st July 2013, 1st Oct 2013 and 1st Dec 2013. Even for year 2014 too.

share|improve this question

Try with the following,

  1. Create a SharePoint Designer (SPD) workflow

  2. Select your task list

  3. Set it to run on Create

  4. Click Next

In the Actions section add these three actions:

  • Add time to date

  • Pause until date

  • Send email

My example looks like this after the properties are set:

Add -7 days to Tasks:Due Date (Output to Variable: ReminderDate)
    then Pause until Variable: Reminder Date
    then Email this message    (you can hard code the address or use the assigned to... )

Notes for this very simple example:

  • If someone edits the task and sets a new due date, this workflow will still send the reminder based on the old date.
  • It does not check to see if the Due Date is at least two days in the future.


share|improve this answer

You can use the SharePoint Designer workflow "Pause Until" or "Pause For" action. Microsoft touches on them briefly in their documentation:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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