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

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.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"ccnlc1" <(E-Mail Removed)> wrote in message
news:e2fa5ea0-a733-4394-b4ea-(E-Mail Removed)...
>
> Any way/How to print out 2 rows of labels for each person of my 120
> persons Excel Database?
>

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
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Suzanne S. Barnhill wrote:
> 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.
>
>
> "ccnlc1" <(E-Mail Removed)> wrote in message
> news:e2fa5ea0-a733-4394-b4ea-(E-Mail Removed)...
>>
>> Any way/How to print out 2 rows of labels for each person of my 120
>> persons Excel Database?

Thanks for the caveats and extra info, Graham.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Graham Mayor" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> Suzanne S. Barnhill wrote:
>> 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.
>>
>>
>> "ccnlc1" <(E-Mail Removed)> wrote in message
>> news:e2fa5ea0-a733-4394-b4ea-(E-Mail Removed)...
>>>
>>> Any way/How to print out 2 rows of labels for each person of my 120
>>> persons Excel Database?
>
>
>