Link to home
Start Free TrialLog in
Avatar of tresmanos
tresmanos

asked on

SharePoint 2007 Alert Based on Date Filter

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

ASKER CERTIFIED SOLUTION
Avatar of KoenVosters
KoenVosters
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Daryl Sirota
Daryl Sirota
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tresmanos
tresmanos

ASKER

Both are good ideas, I will look into these.  Thanks for your input, much appreciated.