 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / August 2005Number 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.  SignatureS 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. SignatureHope 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 >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 [quoted text clipped - 5 lines] > for > any help you can give me. 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. SignatureS 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. [quoted text clipped - 8 lines] > > for > > any help you can give me. 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. SignatureS 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. [quoted text clipped - 8 lines] > > for > > any help you can give me. See http://www.gmayor.com/Numbered_labels.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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 [quoted text clipped - 3 lines] > 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? SignatureS Jan > See http://www.gmayor.com/Numbered_labels.htm > [quoted text clipped - 5 lines] > > 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? SignatureHope 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 >I did the Insert, Field, {SEQ Label}, but still got labels numbered 1-20 on > each sheet of labels. What did I do wrong? [quoted text clipped - 8 lines] >> > 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 > Did you actually execute the merge to a new document? > [quoted text clipped - 10 lines] > >> > 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 Edit>Replace with ^b in the Find what control and ^m in the Replace with control to replace the Section breaks with manual page breaks. SignatureHope 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 > yes, I did complete the merge. As a review, i clicked on Insert, then > Field, [quoted text clipped - 21 lines] >> >> > numbered 1 thru 150 without having to manually number them myself >> >> > after the merge? Thank you for any help you can give me. Thanks - I'm going to try it right now. SignatureS Jan > It would appear then that the numbering is restarting at the section break > between each page of labels. Try using Edit>Replace with ^b in the Find [quoted text clipped - 26 lines] > >> >> > numbered 1 thru 150 without having to manually number them myself > >> >> > after the merge? Thank you for any help you can give me. 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!. SignatureS Jan > It would appear then that the numbering is restarting at the section break > between each page of labels. Try using Edit>Replace with ^b in the Find [quoted text clipped - 26 lines] > >> >> > numbered 1 thru 150 without having to manually number them myself > >> >> > after the merge? Thank you for any help you can give me. 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+* ) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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 [quoted text clipped - 55 lines] >>>>>>> number them myself after the merge? Thank you for any help you >>>>>>> can give me. 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 :( Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > It would appear then that the numbering is restarting at the section > break between each page of labels. Try using Edit>Replace with ^b in [quoted text clipped - 45 lines] >>>>>> number them myself after the merge? Thank you for any help you >>>>>> can give me. 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 > 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 [quoted text clipped - 52 lines] > >>>>>> number them myself after the merge? Thank you for any help you > >>>>>> can give me. 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. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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 [quoted text clipped - 70 lines] >>>>>>>> number them myself after the merge? Thank you for any help you >>>>>>>> can give me. 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? SignatureS Jan > 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 [quoted text clipped - 52 lines] > >>>>>> number them myself after the merge? Thank you for any help you > >>>>>> can give me. 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 :( Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > This is interesting: I inserted Section {SECTION} on my labels just > to see what is happening with the section numbers and it printed out [quoted text clipped - 68 lines] >>>>>>>> number them myself after the merge? Thank you for any help you >>>>>>>> can give me. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.