Label Counter Starting One Higher in the Next Page

L

LiCal

My mail merge Label Doc prints 3 labels (with counter number) on each
standard letter size paper. I use the below Field embedded in the
label doc for the rec/label counter purpose.

1) for the first label
{ ASK start "Start number" \d "1" \o }
{ ASK start "Start number" \d "1" \o }{next}

2) for the 2nd/3rd label
{ ={ start } + { mergerec } - 1 } {next}


The mail merge operation runs OK, ending with a new doc of about 120
labels, each with own counter number.

The problem is the counter number starting on the next page. In the
same page, the counter numbers run consecutively, the new page would
skip one, starting at 2 higher from the end of the previous page.

What may be the problem, and how to resolve it?
 
D

Doug Robbins - Word MVP

Remove the { next } from the third label. The normal position for it is
BEFORE the first mergefield in all labels on the sheet EXCEPT for the FIRST.
But as you have it AFTER the mergefields in the First and Second labels, you
do not need it after those fields in the Third label as the mail merge
process automatically indexes to the next record when moving from one sheet
to the next, without the need for the { next } field.

--
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
 
C

ccnlc1

Thanks Doug, but it did not work for my situation, as I have 3 labels
in one sheet.

After removing the { next } from the 3rd label as suggested:
with Start @201
1st Sheet
201, 202, 202
2nd Sheet
204,205,205
and so on.
 
D

Doug Robbins - Word MVP

I am not sure why you have the two ASK on the first label

for the first label
{ ASK start "Start number" \d "1" \o }
{ ASK start "Start number" \d "1" \o }{next}


If I set up the first label with

{ ASK start \o }{ = { Start } + { Mergerec } - 1 }

and then on the other labels on the sheet, I have

{ Next }{ = { Start } + { Mergerec } - 1 }

Then when I execute the merge I insert 201 into the Ask dialog, the labels
are number correctly without any skipping of numbers between sheets.

--
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
 
L

LiCal

It works, no more counter number skipping on starting the new sheet.
Appreciate very much for your help.
 

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