Merging different quantites of labels based on Excel data
 

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, I have a file that does this, but don't want to share it with
the public. Email me and ask for LabelMaker, and I'll send it to you. Quite
honestly, I was thinking about making it generic in some way and for resale.
But I'll give it to you if you tell me what you think of it.

*******************
~Anne Troy

www.OfficeArticles.com


"JDellenger" wrote in message
...

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