CODEWITHSUNDEEP
sharepointsharepoint-2007
Rushikesh
Rushikesh

Reputation: 529

How to send automatic email notification to user two days before expiry date

In SharePoint 2007 document library I want to send automatic email notification to user two days before expiry date. After expiry date document will remain in the library. Any suggestions would really be appreciated.

Upvotes: 0

Views: 17858

Answers (2)

user3012895
user3012895

Reputation: 21

Create a SharePoint Designer (SPD) workflow Select your task list Set it to run on Create 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.

Ref: http://social.msdn.microsoft.com/Forums/en-US/acb12dd2-d6a5-4b7e-b233-037558bfa2e5/start-workflow-x-days-before-expiry-date?forum=sharepointcustomizationlegacy

Upvotes: 0

Greg
Greg

Reputation: 944

You just need to create workflow in SharePoint designer. During creation of an item the workflow starts and waits until execution date. If expiry date can be changed you need another action which cancels old workflow (with old date) and starts new one (with need date).

Here you can find instruction how it can be done in SPD

Upvotes: 1

Related Questions