Macropod,

Thanks for the reply,

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...



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.

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?

Dave

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:
Did you do that?
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
After {SET QTY {MERGEFIELD Quantity}}, you could insert a field coded as {FILLIN "Quantity: {REF QTY}"}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Macroprod,

Thanks so much for your patience...

I had used the referenced script to convert text to code...

I had copied the fields to each label as per your original instructions.

After a careful re-read of your tips and tricks, I double checked the data type in the Quantity field of my dataset. It was in fact a number as text. Converting that column to a number seems to have solved the issue.

Your code does in fact work as advertised, I thank you profusely for sharing it.

Now on to the matter of formatting the label and including a barcode for the SKU.


Not a request, just a musing.


Thanks again for your invaluable assistance.