Printing the same label n times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel databasewith the following fields:

PO
SKU
Name
Quantity

and I need to print each label as many times as the field Quantity
indicates. How do I print them without having to repeat each row per label?
I'd like to use the field Quantity as a counter.

Thanks!
 
Hi =?Utf-8?B?QWdhbmRhcmE=?=,
I have an Excel databasewith the following fields:

PO
SKU
Name
Quantity

and I need to print each label as many times as the field Quantity
indicates. How do I print them without having to repeat each row per label?
I'd like to use the field Quantity as a counter.
Click to expand...
There's really no good way to do this with mail merge. Although there are
workarounds, as soon as the number of labels doesn't exactly match the number
of labels on a sheet (you have a combination of 4 and 5, for example, but an 8
label sheet) you're totally out of luck.

You either need to export the data to another ("temp") worksheet, with the
duplicated number of rows, or set up the labels in Excel and use a macro
solution within Excel.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
Back
Top