Search results

Hi all, Been racking my brains on this one for age on the below problem . I'm trying to send a HTML mail to a list of people regarding their unpaid invoices. The code below does the job perfectly but ... I can run a query showing all results, however one person could have multiple unpaid...