First, let me start with my scenario.
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?