Reply
 
Thread Tools Display Modes
  #1   Report Post  
Sagit
 
Posts: n/a
Default Number each label in the mail merge step so it is done automatical

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.
--
S Jan
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

Modify the merge datasource so that it contains a field with the numbers.
Easiest way to do this would be to out it into Excel.

--
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
...
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.
--
S Jan



  #3   Report Post  
Graham Mayor
 
Posts: n/a
Default

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.



  #4   Report Post  
Sagit
 
Posts: n/a
Default

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.




  #5   Report Post  
Sagit
 
Posts: n/a
Default

Doug: The source program that creates the original table is so old, that I
have to go thru 5 steps (delete delimiters, replace paragraph with tab,
convert to text to table, convert table back to text, save as a text file)
just to get it in an acceptable form for Excel. For a Word table, all I have
to do is change the record and field delimiters. I may be forced to use
Excel, but if you have any other suggestions, please let me know. Thanks for
so much.
--
S Jan


"Doug Robbins" wrote:

Modify the merge datasource so that it contains a field with the numbers.
Easiest way to do this would be to out it into Excel.

--
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
...
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.
--
S Jan






  #6   Report Post  
Sagit
 
Posts: n/a
Default

Doug,
I went ahead and got the file in a format that was acceptable to Access
(Access automatically numbered each record) and did a mail merge with that.
A strange thing happened: the first page of labels was numbered 1-20; the
second page was numbered 2-21, the third page 3-22, etc. Access has each
record numbered 1-150, so I can't figure that one out. Any ideas? Thanks
for you help.
--
S Jan


"Doug Robbins" wrote:

Modify the merge datasource so that it contains a field with the numbers.
Easiest way to do this would be to out it into Excel.

--
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
...
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.
--
S Jan




  #7   Report Post  
Doug Robbins
 
Posts: n/a
Default

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.






  #8   Report Post  
Sagit
 
Posts: n/a
Default

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.






  #9   Report Post  
Doug Robbins
 
Posts: n/a
Default

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.

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








  #10   Report Post  
Sagit
 
Posts: n/a
Default

Thanks - I'm going to try it right now.
--
S Jan


"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.

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











  #11   Report Post  
Sagit
 
Posts: n/a
Default

I tried the replace at every stage of the merge and I kept getting the
message that 0 replacements were made. Thanks for all you are trying to do
for me - I really appreciate your patience!.
--
S Jan


"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.

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









  #12   Report Post  
Graham Mayor
 
Posts: n/a
Default

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.



  #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.




  #14   Report Post  
Graham Mayor
 
Posts: n/a
Default

Using LISTNUM fields rather than SEQ fields, which is where you started, the
fields do carry to the merged document. You can manually delete the section
breaks (if Doug doesn't come up with a macro ) by inserting a temporary
paragraph mark before the first page table and displaying the formatting
(CTRL+* )

--

Graham Mayor - Word MVP

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


Sagit wrote:
I tried the replace at every stage of the merge and I kept getting the
message that 0 replacements were made. Thanks for all you are trying
to do for me - I really appreciate your patience!.

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.

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



  #15   Report Post  
Sagit
 
Posts: n/a
Default

This is interesting: I inserted Section {SECTION} on my labels just to see
what is happening with the section numbers and it printed out Section 1 on
all the pages! I would have expected the section number to change on each
page of labels. I knew Word looks at labels as one long page, but with
numerous sections.
Also, I would have expected the SEQ to be correct if Word thought that there
was only 1 section. Does this shed any light?
--
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.






  #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.



  #17   Report Post  
Graham Mayor
 
Posts: n/a
Default

There are definitely section breaks between the tables and different section
numbers are shown in the status bar. There is clearly an anomaly here. How
to correct it is another matter entirely

--

Graham Mayor - Word MVP

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


Sagit wrote:
This is interesting: I inserted Section {SECTION} on my labels just
to see what is happening with the section numbers and it printed out
Section 1 on all the pages! I would have expected the section
number to change on each page of labels. I knew Word looks at labels
as one long page, but with numerous sections.
Also, I would have expected the SEQ to be correct if Word thought
that there was only 1 section. Does this shed any light?

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.



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 label only puts one label per page? Ebb Berry Mailmerge 4 April 21st 23 12:06 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
How do you add a label product to mail merge? scanatc Mailmerge 1 March 23rd 05 04:25 PM
Mail Merge Final Step in Word 2003 XP blnorwood Mailmerge 2 January 14th 05 06:02 AM
Step By step mail merge 287 names on labels Jenny New Users 2 December 12th 04 12:53 AM


All times are GMT +1. The time now is 10:31 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"