Hi All,

- I want to send an email based on date(Before 2 week from mentioned date)

- I don't have development environment like vs studio , SP foundation to develop Timer job.

- Can develop designer workflows only.

How can i send mail based on date. So, in this case i have to run the workflow on all list items in order to check date and send mail.

Hi Niraj,

You can achieve this very well using a SharePoint Designer 2013 workflow. There are multiple ways of achieving this.

• You can define a variable when the notification has to be sent. (based on your business needs)
• Then you use "Loop until condition" control in SharePoint designer workflow
• Give the necessary condition, (Like NotifyVariable >= Today)
• Then send the email and end the workflow after notification.
• Refer the below screenshot for reference.

Hi Arjun,

Thanks for your reply, i will try this solution and will update

• Edited by NirajZ Wednesday, August 26, 2015 10:41 AM

Hi Arjun,

Thanks for your reply, i will try this solution and will update

• Edited by NirajZ Wednesday, August 26, 2015 10:41 AM

Hi Arjun,

"Loop" option is not available in my SP Designer 2013, as Workflow for 2013 platform is not configured yet.

Is there any alternative that i can use?

I did it using "Pause" action and resolved

• Marked as answer by NirajZ Friday, August 28, 2015 12:28 PM

I did it using "Pause" action and resolved

• Marked as answer by NirajZ Friday, August 28, 2015 12:28 PM

Hi,

You can use Pause Until in SharePoint workflow 2010 platform like the capture below:

Thanks

Best Regards

Hi Jerry,

I am able to meet with conditions with "Pause Until" condition in Worflow.

But have a doubt that if i paused the workflow till the date and status =="Approve".

Now the date in above condition has been passed but the record has not been approved, so lets say if i approve the record after the mentioned date, will it work(like sending an email notification).

If it will work, it means that "Pause Until" will hold the workflow till the date and starts working as soon date is equal or Greater than mentioned date?

Please let me know?

Hi,

Yes, "Pause Until" will make workflow start when the current date exceed the mentioned date.

Thanks

Best Regards