View Single Post
  #13   Report Post  
Sagit
 
Posts: n/a
Default

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.