We have a custom SharePoint list that we use to control all our company’s work. Managers will add items for the staff to do. It includes things such as the client, work required, due date and current status (Not started, in progress, completed). Each Item is also assigned a manager and an operative.
I am wanting to set up an email that will be sent to each manager each week, showing all their items that are incomplete, and either overdue, or due in the next.
I can set it up as a view, but can’t seem to find a way for the email to find all items that match that criteria, it only finds the first one.
Is there a solution to my problem?
Check out http://wonderlaura.com/Lists/Posts/Post.aspx?ID=224 for an example of what Marta is talking about. Also, if these are just list items, you could build a report off of it if you have some experience doing that.
