I have a databsae that includes the invoices of different companies. I have
created a sendobject macro for each indvidual company that send emails to
their company if they have not paid for their invoice. I have also created
a
macro that sends all the emails at once with just the click of that one
macro. My problem is that I can not figure out a way to only send the
emails
all at once to just the companies that have unpaid invoices, the companies
that have paid do not get any email messages. I want to be able to send
these
emails out weekly. Any suggestions is greatly appreciated. Thanks
