We have developed a Crystal report to output Supplier Statements which will update supplier on invoices that are open/status/value/due date.

We have details of e-mail addresses in IFS that we would ike these to go, and a standard e-mail template to attach.

However, when we run the report, the program sends all supplier statements as a multi-oage PDF to the first contact address on the list.

Is there a way that these can been broken down so that when running the reports, each supplier receives only their statement?