Skip to main content
Participant
September 27, 2019
Question

Output variable quantities from data merge

  • September 27, 2019
  • 1 reply
  • 206 views

Hi everyone,

I need to generate multiple labels from a spreadsheet. The last field is Quantity, that represents the number of labels I need to print for each record.

Is there a way to generate a file where each record is repeated N times, where N is the value on the column Quantity? So 20 copies of the first label, then 5 copies of the second, 25 of the third and so on.

Maybe can it be automated with scripts or a third party plugin?

Thanks in advance!

This topic has been closed for replies.

1 reply

Participant
September 27, 2019

Update: So I ended up finding a VBA code to duplicate the rows for the quantity cell value in my Excel spreadsheet.

Now hopefully data merge can handle my 17,000+ list. 😜