inform the correct documents SQL HTML table in e-mail body

Hello, 

We currently send the invoices via e-mail using the P&D, with a SQL HTML table to list the details of the invoice being attached in the body. 

Now we need to group e-mails per Business Partner, function already available in P&D.

How can I identify the documents being grouped by PD so I can correctly list the invoices in the e-mail body using the SQL HTML Table. 

When using the keyword of the document number  $[$8.0.0] as a filter in the SQL, only shows the first invoice, of course. 

How can I collect all the documents being sent?