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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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