Mail merge - Number of records

I have a excel inventory and use mail merge to print labels for the inventory.
I print the same day I order parts so I filter by the column with the order quantity.
I would like to print the number of labels for the quantities. (ie if I order 4 parts, print 4 labels)
Is there a way to do this?

I currently have 3 identical labels print (1 row) for each part. That is the average quantity I order.

Follow up for a little clarity.
How can I print multiple labels from the same line?

Example
Item Desctiption Quantity Price
1 power supply 2 3.50
2 Memory 3 24.50


I would want to print these quantities.

Whew! Thank you for the reply. That is something to think about. I've been doing this for a while and have always wondered about this aspect. What if you want X number printed.
I don't know of any higher math that can be done with those logical commands in the mail merge. Currently I just have one row print the same thing, then go to the next item on the next row. 3 of everything... So now I order 3 of everything! lol

This was super helpful! Thank you!

Originally Posted by teylyn

Hi again,

I've done a little macro that will create a suitable list of records for the merge. The most important thing is that the sheet with the merge data is the first tab in the workbook, otherwise you may run into trouble with the merge,

So, create a new, empty sheet in your workbook before Sheet1, then copy this macro into a code module, adjust the settings I've outlined in the comments, and give it a go.

You could create a button in the sheet where you enter the items, so you click the button to run the macro. See attached.

Please Login or Register  to view this content.

let me know if this works for you!

cheers