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

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

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

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

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.

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.

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.

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.

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.