Mail Merge with Variable Table Length
Hi,
I have an excel file with the following details:
Invoice No. |
Item Code |
Amount |
|
|
|
|
|
|
|
|
125.00 |
|
|
105.00 |
|
|
735.00 |
|
|
35.00 |
|
|
846.00 |
I need to prepare a Mail Merge of over 100 invoices. Each invoice may have 1 or more item codes. But the mail merge should make the 2nd item to appear on a row below the 1st item if there are more than 1 items against an invoice number.
For example: Invoice Number has 2 item codes against it. So the mail merge automated invoice template should display both the items one below the other along with the amount.