Reminders on Sharepoint 3.0

Posted on 2011-05-03
Last Modified: 2012-05-11
I have a Custom List in a SharePoint Services 3.0 which contains a date field.
This date field is an expire date for a contract (this may be one or two years in the future)
I would like the system to send an email two weeks before the expire date of the contract.
Normally I would use a workflow that triggers when a new item is added or modified, but I need the system to do a daily check thru all the records in the list and email if any of the dates falls within two weeks from Today.
Can this be done in WSS 3.0?

Thanks in advance

Question by:caratech
    LVL 7

    Expert Comment

    You won;t do this out of the box.

    I am not sure I would use a workflow though as it would then be visible to users.

    This is very much a background process which only interacts with users when an email is to be sent.

    I think the best approach would be to use a custom SPTimerService object that polls the list looking for items and sends the emails.

    Author Comment

    any ideas on how to achieve this?
    Any links to show step by step guides?

    Thanks again
    LVL 7

    Accepted Solution

    First look at this article to help you build and register a timer job.

    This job will need to read a list of items where the date is within the next two weeks. I would suggest using a CAML query to do this.

    Have a look here:

    Another thing you will need to do is make sure the email is not sent twice so some way of marking the list item has being dealth with. Also be aware that these timer jobs run on every server in the farm so you will need to make sure it has some way of dealing with this too. Not simple I'm afraid.

    Author Closing Comment

    Thanks for your help. I was able to get it working.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
    Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now