I may have to go with a simpler solution.
The cursor is almost done, just need to add the dp_send_dbmail part.
I will revisit Lowell's solution when I go back to the main reports.
I'm going to open a new post for that since it is outside the scope of the original topic.
Thank you for your help.