Solved

SharePoint 2007 Alert Based on Date Filter

Posted on 2011-02-15
3
964 Views
Last Modified: 2012-06-21
I have a SharePoint View on a list that calculates when the list item was last updated using [Today]-1 based on the default field "Modified".  The filter is typed out below also.  The view works perfectly but I am unable to send an email alert if anything pops up in this view.  I believe that in order for an email alert to work, a list item has to be modified.  In this filter, nothing is being modified, it is just a list item that is aging and eventually meets the criteria to show up in this view if it is not touched within 24 hours.  

Is there any way to send an email to a person when items show up in this view?  

Show the items when column "Modified" is less than [Today]-1
and
When Column "Status" is not equal to "Resolved" 
and 
When Column "Status" is not equal to "Closed"

Open in new window

0
Comment
Question by:tresmanos
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 14

Accepted Solution

by:
KoenVosters earned 300 total points
ID: 34900408
You can create a custom timer job that sends out alerts. The job runs once a day and checks the list to see if an item is expired:
http://www.andrewconnell.com/blog/articles/CreatingCustomSharePointTimerJobs.aspx

There is also a full code example here:
http://www.codeproject.com/KB/sharepoint/SPScheduedReminders.aspx
0
 
LVL 11

Assisted Solution

by:FastFngrz
FastFngrz earned 200 total points
ID: 34902708
You could also write a workflow with sharepoint designer that waits 'x' days and then sends an email.  No code!
0
 

Author Closing Comment

by:tresmanos
ID: 34970908
Both are good ideas, I will look into these.  Thanks for your input, much appreciated.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

751 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