I have a worksheet that I am trying to do a mail merge from to print mailing
labels. There is a column that is labeled quantity and has a list of numbers
in it.

I need to be able to print a different number of each label...based on the
number that is in the quantity column.

Is there any way that I can do this? For example, if my quantity column has
the value 3...I need to be able to print 3 labels that say "Box 1 of 3", "Box
2 of 3" and "Box 3 of 3" as one row of the merge.

Does anyone have any ideas of ways that I can maybe use multiple formulas to
do this????

Any help would be GREATLY appreciated!!!!!!!!!

JDellenger

This can perhaps only be realised through using VBA.

In your example, if the quantity against an item is 3, then you might
want to insert (3 - 1) rows just under the row for this item. Then in a
column perhaps next to the quantity column you might want to print "Box
1 of 3" in the first row of this item, "Box 2 of 3" in the second row
of this item and "Box 3 of 3" in the third row of this item.

I don't know whether you want to go down this path but this in my
opinion is one of the options that may be available to you!


Best regards



Deepak Agarwal


--
agarwaldvk
------------------------------------------------------------------------
agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345
View this thread: http://www.excelforum.com/showthread...hreadid=385430