Check form submissions on a quarterly basis

I have a small project plan that contains just 4 tasks - 1 for each quarter of the year, with the due date being the last workday in the quarter.

Using that plan and an Outlook distro list, I have roughly 200 people that, based on the quarterly end date, will get a link to a form to complete for their location using one of 3 reminders: 2 weeks before, 3 days before, and on the actual due date. All 3 have the form link.

What I'd like to do is:

  • Once a person submits the form for a location for a quarter, they stop getting the reminder
  • On due date+1, generate a report that lists everyone who has NOT yet submitted the form for that quarter

All suggestions appreciated!