print variable number of copies of labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

henryl - 16 Jan 2006 10:40 GMT

I have a need to print a variable number of labels when merging from Excel.
I.E. record 1 may need 5 copies of the same label, record 2 3 copies, record
3 15 copies. The number of copies is a field on the record. Is there a way
to use this field to print the number of copies neede?

TIA
HenryL

Reply to this Message

Doug Robbins - Word MVP - 16 Jan 2006 12:29 GMT

That degree of variability is probably beyond the scope of a field
construction using the Next Record If field. I think that you are going to
have to use Visual Basic to populate the cells of the table that forms the
labels rather than mail merge.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a need to print a variable number of labels when merging from Excel.
> I.E. record 1 may need 5 copies of the same label, record 2 3 copies,
[quoted text clipped - 5 lines]
> TIA
> HenryL

Reply to this Message