2 Rows of Labels for Each Person -- Avery Labels (5267 / 5260)

C

ccnlc1

Any way/How to print out 2 rows of labels for each person of my 120
persons Excel Database?
 
S

Suzanne S. Barnhill

Assuming the label sheet has an even number of rows, after propagating the
labels but before completing the merge, delete the «Next Record» field from
the all but the last label in every two rows; that is:

Row 1: omit «Next Record» from all labels
Row 2: «Next Record» in last label only
Row 3: omit «Next Record» from all labels
Row 4: «Next Record» in last label only

and so on. Since these labels seem to have 10 and 20 rows, this should be
feasible.
 
G

Graham Mayor

Some versions of Word contrive to replace the missing Next Record fields
from label merge documents at the drop of a hat. To avoid this, change the
document type to Letter after propagating and before removing the un-needed
Next Record fields fields.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top