msiyab
03-11-2019, 12:05 PM
Hi,
I have an excel file with the following details:
Invoice No.
Item Code
Amount
490502688
117363
589.00
490502688
117380
713.00
490502689
117380
125.00
490502692
69384
105.00
490502692
105009
735.00
490502692
116531
35.00
490502692
161556
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.
I have an excel file with the following details:
Invoice No.
Item Code
Amount
490502688
117363
589.00
490502688
117380
713.00
490502689
117380
125.00
490502692
69384
105.00
490502692
105009
735.00
490502692
116531
35.00
490502692
161556
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.