Re: Merging different quantites of labels based on Excel data

Tech-Archive recommends: Fix windows errors by optimizing your registry



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" <JDellenger@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BF1CFD07-3033-4D32-8C43-EF91E866BDC9@xxxxxxxxxxxxxxxx
>
> I have a work*** 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!!!!!!!!!


.


Quantcast