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

Attached Files

	Test MM Template.docx (44.9 KB, 33 views)
	Debt Recovery File.xlsx (9.7 KB, 30 views)