I have a list of outstanding invoices for several customers. I regularly need
to issue statement based on list of open invoices. I wish to create a
template where i would select individual records to chase payments.

I wish the template would accomodate one or more lines depending on number
of open invoices for one customer.

my list contains one line for each and every transaction i.e invoice number
transaction date, customer order number,details, outstanding amt.

I was also considering emailing the statement directly from Excel, but this
is not my current priority.
Anyone can help?