Dear SharePoint experts,
We would like to ask for tech support on how to create Email alert when due date is approaching using SharePoint Workflow.
SharePoint 2013.
We have a list with this fields:
– Name of users
– Email
– Setup Date
– Password Expire
What we want to happen is to set an alert, Email alert to the user(s) 5 days before their password expiration arrives.
We’ve created other workflows with Email alert already, but that workflow is sending email to ALL and not to single user only.
But with this workflow, we want one or several users to receive an email separately, 5 days before their password expires.
Thank you and hope to hear soon…
I’ve created a similar workflow for reminder for meeting-actions. You need to create 2 columns: “EmailReminderCount” (number) and “FirstEmailSent” (yes/no column with default no)
You will need to build 2 workflows: one that will change the column FirstEmailSent to yes, and set EmailReminderCount to 1, and will sent the email to the person in your Name-column. From that point on, depending on the status of the item, the workflow will count +1 in the column EmailReminderCount. This will create a change in the item, therefor starting the 2nd workflow.
The 2nd workflow is to fire up the first one again, this one will just add +1 in the EmailReminderCount column. Also creating a change, and therefor starting the first workflow again so that emails will be sent again and again and again 😉 (if wanted)
Hope this will help a bit
