Hi,


I have a table in excel - x rows, 6 columns for example:

no of lines pr qty price total price VAT currency ....
10 203555 2 100 120 gbp
20 203555 5 100 120 gbp
30 203555 6 80 100 gbp
10 204678 1 10 12 gbp
10 203787 1 8 10 gbp
20 203787 1 10 12 gbp
etc.....

I want to export in a word template in order to create multiple invoices and I was tried to make this using mail merge from word but I'm not able to put 3 lines in a single invoice, then one line in the second one, then 2 lines in third. The ideea is to create a mail merge with rules or a macro in excel which will be able to create 50 or 60 individual invoices for which I have a template.
thank you