Excel to Word Table via Mail Merge

[ged147]

I am trying to merge invoice data from an Excel file to an MS Word Letter template (see attached file).

I have 2 issues:-

1. I am unable to include multiple invoice lines for the same company in each letter As a workaround I have therefore created separate columns with unique column names eg invoice_id, invoice id 1-4, invoice date, invoice date 1-4 (see Excel file example).
2. If I stick to the method above how can I exclude blank lines from the word table where the company only has 1 invoice. I have created the table with 5 rows as a default.



Questions
Is there a simple method for including a multi row MS Word table in the letter?
OR
How can I suppress NULL rows in the Word table as part of the mail merge?

Thanks.

Ged