Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
LiCal LiCal is offline
external usenet poster
 
Posts: 2
Default Label Counter Starting One Higher in the Next Page

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?




  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Label Counter Starting One Higher in the Next Page

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

"LiCal" wrote in message
...
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?






  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
ccnlc1 ccnlc1 is offline
external usenet poster
 
Posts: 4
Default Label Counter Starting One Higher in the Next Page

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.





  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Label Counter Starting One Higher in the Next Page

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

"ccnlc1" wrote in message
...
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.







  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
LiCal LiCal is offline
external usenet poster
 
Posts: 2
Default Label Counter Starting One Higher in the Next Page

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


  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Label Counter Starting One Higher in the Next Page

If you are numbering labels, you might find
http://www.gmayor.com/Numbered_labels.htm useful.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge page counter Richard Vanterve Mailmerge 3 September 30th 07 06:49 PM
I want to add a visitor counter to an web page. fredj000 Microsoft Word Help 3 September 12th 07 06:44 AM
Choosing starting label RolandB Mailmerge 5 May 26th 07 12:23 AM
HOW DO YOU CHANGE THE STARTING LABEL IN A MAIL MERGE? anjjohnson Mailmerge 1 October 7th 06 07:29 PM
Need to print a single label starting at row 1 column 2 CYCLIST Microsoft Word Help 5 April 16th 06 10:14 PM


All times are GMT +1. The time now is 11:08 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"