I am trying to use SharePoint designer to send an email notification 30 days before Original Due date. also, if the status field is not equal to close, the system should send email every 14 days.

I have difficulties to get the second part which needs to keep sending email until the status is close. Can you please help?

enter image description here

  • So Harris, did you fix your issue? Or did you find another way to make it work? I'm waiting in suspense to know whether you got this working...the silence is killing me..
    – Tally
    Jun 4, 2021 at 13:14

2 Answers 2


For 2010 workflow, you will need to use a tricky way to do this without loop. Using two workflows like this blog. Or you may need to set up a windows task which will initiate a workflow every 14 days, check the status and then send a Email


I'm going to give you only a part-answer and another option. Windows Task Scheduler can be used as your 'date trigger', the WTS task can be configured to kick off a powershell script. The end product is that an email is sent out.

I had a similar scenario here, please read the answer for an outline of this method. It's been ages since I did this though, I've since changed jobs so no longer have the .ps script I used. But you could try doing some research on this if it seems promising for your scenario.

For reference

How to create an automated task using Task Scheduler on Windows 10.

You'd still need to find a suitable powershell script though.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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