send past due notices

[Ken Ivins]

I want to send a list of past due customers via email to the respected sales
people using code. Each salesperson will only receive their list of people.
I assume I create a report and use SendObject to send this snap shot. I can
do this one at a time but to send them all is what has me baffled. I assume
I use some kind of loop to create a new report based on a different
salesperson. Also if a sales person does not have anyone past due then no
email will be sent.

I have a customer table, a billing table, a payment table and a salesman
table (that has their name and email, etc.).

Thanks,
Ken