My solicitors want to be able to see when their assigned people fall behind on commitments or have installments due soon so that we can be more proactive about working with the donors instead of just sending reminders. I have looked at a ton of reports but some don't have solicitor as an optional...

How can we send pledge reminders to couples on our list who wish to be together on our mailing list for newsletters, etc, but who need to keep their giving records separate?