I have a Data Sheet type list, where I have items with fields - Title, Start Date, End Date, Person allocated, and a comment column.

Now how can I create a workflow to trigger, when the elements end date is due within 4 days. And the mail should go to the person allocated, with comment column fields.

I am not sure how to send mail, only when the end date is due with in 4 days. And how to send it to the person in the allocated column!!

Please help me on this!!

2 Answers 2


This can be done using a custom timer job which triggers an email when this condition is met.

  1. Create a custom timer job which checks the list for all items end date.
  2. If the end date is duw within 4 days, get the person allocated from the list item and get his email id.
  3. Trigger an email with the person's email id with the comments column as the matter.

You can schedule the timer job to check the site for each 5 minutes or so (In the central admin), based on the requirement.

  • Thanks Deepu bayya, How ever, how can I create a timer job in Sharepoint!! Do I need to use some Windows Service!!
    – Jithu
    Dec 26, 2011 at 9:37
  • I shall send you some sample code while I reach home..that should help you to start with..
    – Deepu Nair
    Dec 26, 2011 at 10:17
  • Hi, Create a class which extends the class SPJobDefinition... and you will have to write your code in the method 'Execute'.. You can search in google... lots of example are available.. for implementing Timer jobs in SharePoint
    – Strider
    Dec 26, 2011 at 11:53
  • Thanks paddy, Deepu had sent me a sample snippet, let me try with that and will let you know the progress!!
    – Jithu
    Dec 27, 2011 at 4:41

You should create a custom expiration policy and bind it to the list in the Information management policy settings of the list.


This is for 2007 but the same rules apply.

Your Answer

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

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