Excel to Word Table via Mail Merge
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
|