We currently distribute several NPrinting reports via email using an excel list of the recipients that includes a filter for their name as either the Project Manager or Program Manager. It also groups them by Program (e.g. A, B, C). The reports are distributed by Program and Project Manager. The Program Managers receive a version of the reports for all projects in their respective program.
The process to maintain this file seems too manual and tedious. If a new project is added with a new Project Manager, for example, we would have to know about it or run a query before the reports run to manually add the person to the recipient list.
I'm wondering how other people handle maintaining their recipient lists and if you have any suggestions for me.