View Single Post
  #16   Report Post  
Graham Mayor
 
Posts: n/a
Default

Numbering using the Excel method will not cause this problem, but where
other data is required, it relies on having the number list and the data in
the same file.

--

Graham Mayor - Word MVP

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



Sagit wrote:
I tried Plan B described on your web site using Exel (the first time
I tried it I used Access because it numbers automatically when I
paste the table into it) and the result was the same: the labels
were numbered 1-20 on the first sheet of labels, 2-21 on the second
sheet, 3-22 on the third, etc. You say on your website that this
plan is ideal for a table where only the number changes. Of course,
with my address file, everything changes. Would this make a
difference? I do appreciate all your efforts in helpiing me. I am
using Word 2002 under Windows XP, if that is any help. S Jan


"Graham Mayor" wrote:

Hmmm. This worked when I prepared that web page, but now it doesn't
and yes the numbers restart at the section breaks. Unfortunately
swapping the section breaks for page breaks (or deleting the section
breaks) doesn't help for after the merge the SEQ fields are
converted to text. Until I can work around a solution for this, it
looks as though the alternative method will have to be used

--

Graham Mayor - Word MVP

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


Doug Robbins wrote:
It would appear then that the numbering is restarting at the section
break between each page of labels. Try using EditReplace with ^b
in the Find what control and ^m in the Replace with control to
replace the Section breaks with manual page breaks.


Doug Robbins - Word MVP
"Sagit" wrote in message
...
yes, I did complete the merge. As a review, i clicked on Insert,
then Field,
under categories, numbering, then SEQ, then Label as identifier,
then OK. After I updated labels, I merged to a new document, went
to Print Preview, and saw that all label sheets started over 1-20.
I even tried a switch \n just for kicks.
S Jan


"Doug Robbins" wrote:

Did you actually execute the merge to a new document?

--
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
"Sagit" wrote in message
news I did the Insert, Field, {SEQ Label}, but still got labels
numbered 1-20 on
each sheet of labels. What did I do wrong?
--
S Jan


"Graham Mayor" wrote:

See http://www.gmayor.com/Numbered_labels.htm

--

Graham Mayor - Word MVP

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


Sagit wrote:
I have a file with 150 names. I would like to number each name
1- 150
automatically in a label mail merge. I go to Insert, Field,
click on
numbering, then listnum, then number each label, 1-20, on the
mail merge page, then update labels. After I merge, I get each
page of labels numbered 1 - 20. Is there a way to have my
labels of names numbered 1 thru 150 without having to manually
number them myself after the merge? Thank you for any help you
can give me.