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?
1. You could create a complex workflow with SharePoint designer.
2. From Andrew Toh’s blog at http://www.mysharepointadventures.com/2012/06/start-a-workflow-using-powershell/ took his powershell script and revised it to your needs.
3. Easiest way is third party alert and reminder tool, like this http://www.enovapoint.com/junglebell/sharepoint-alerts/
