• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 357
  • Last Modified:

Reminders on Sharepoint 3.0

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

0
caratech
Asked:
caratech
  • 2
  • 2
1 Solution
 
luceysupportCommented:
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.
0
 
caratechAuthor Commented:
any ideas on how to achieve this?
Any links to show step by step guides?

Thanks again
0
 
luceysupportCommented:
First look at this article to help you build and register a timer job.

http://www.andrewconnell.com/blog/articles/CreatingCustomSharePointTimerJobs.aspx

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:
http://sharepointmagazine.net/articles/writing-caml-queries-for-retrieving-list-items-from-a-sharepoint-list

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.
0
 
caratechAuthor Commented:
Thanks for your help. I was able to get it working.
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now