Mail Merge Repeat Record a certain number of times

Taka · #1 07-07-2023, 01:27 AM

I have my data file with the following records:

Lineas;Nombre;Articulo
2;Jose;Plantas
1;Juan;Verduras
1;manuel; carne

and i want to get this result

2;Jose;Plantas
2;Jose;Plantas
1;Juan;Verduras
1;manuel; carne

I have used the combination fields, to obtain a normal combination of them, but I cannot get the macro to work, and the corresponding code.

I have modified the values FIRST_NAME for Nombre, LAST_NAME for Articulo and Quantity for Lineas, and nothing.

I have

Quote:

IF{MERGEREC}= 1 {SET Idx 0}}{IF{Idx}<> {MERGEREC} "{SET Data "{MERGEFIELD Nombre} {MERGEFIELD Articulo}"}{SET QTY {MERGEFIELD Lineas}}{SET Idx {MERGEREC}}"}{SET QTY {=QTY-1}}{REF DATA}{NEXTIF {QTY}= 0

tried before, after the field label, instead of the label, and I don't see how it is, nor have I found more information elsewhere.

Thanks for your help

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Repeat formula 5 times and repeat?	Jenny345	Excel	4	06-14-2013 04:37 PM
mail merge skips 16th record only - of 23 total.	passenger	Mail Merge	1	07-24-2012 04:03 PM
Mail merge to print each record as it is created	PNGento	Mail Merge	1	01-26-2012 02:00 PM
avoid duplicete record and merge the record with the existed record	hemant.behere	Excel	0	01-10-2012 02:53 AM
Extraneous record in Word Mail Merge	aldo13	Mail Merge	0	01-23-2006 01:58 PM