i already have an email sender that analises a ledger and attaches all open invoices to an outlook email , this also creates pdf statements to send to clients and an excel statement with a comment line where customers can comment on invoice payment status , I believe this is adaptable to what you need.