Quote:
Originally Posted by dbrawner
Yes, I am running the code on a mailmerge document for labels. I confirmed the <<next record>> was not present in any label space on the document, and since I was only expecting 6 records to be returned, did not format a second page per your instructions...
|
There is no second page to format per my instructions. All you need do is complete the setup correctly on the first page. As advised in my original post:
Quote:
Originally Posted by macropod
the field codes as depicted above need to be copied to each cell.
|
Did you do that?
Quote:
Originally Posted by dbrawner
I built the code from your post using a macro to convert the text to code. This successfully returned the price, label name, and sku values from the first record in my dataset but did not progress to the next record when the specified three iterations from the quantity field where reached.
|
If the field code has been correctly reconstructed, it should do so. Try the code under
Convert Text Representations of Fields to Working Fields in the
Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
Quote:
Originally Posted by dbrawner
Is there a way to step through the mail merge process to confirm the QTY actually set to the correct value and counts down as expected, and a next record is retrieved when QTY = 0?
|
After {SET QTY {MERGEFIELD Quantity}}, you could insert a field coded as {FILLIN "Quantity: {REF QTY}"}