 |
 | 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 2006skip records in mail merge
I have a data file where fields in a record are listed one below the other i.e. a record is not a line. Each record is made up of 50 lines. I need to extact the address to print labels. The address is located every 20 through 25th line. In mail merge is there a way to skip a constant number of lines? One way to approach this would simply be to put the correct number of <<Next record>> fields (i.e. { NEXT } fields) in your mail merge main document. As long as the number of lines in each record is completely consistent, you may be able to get away with it. Peter Jamieson >I have a data file where fields in a record are listed one below the other > i.e. a record is not a line. Each record is made up of 50 lines. I need [quoted text clipped - 3 lines] > 25th line. In mail merge is there a way to skip a constant number of > lines? Thank you Peter. But is there any of the easier way. It will be a lot of next record that I have to type. > One way to approach this would simply be to put the correct number of <<Next > record>> fields (i.e. { NEXT } fields) in your mail merge main document. As [quoted text clipped - 9 lines] > > 25th line. In mail merge is there a way to skip a constant number of > > lines? You only have to type them once, into your mail merge main document. Then use cut-and-paste (or if you are doing a label merge, you may be able to use "propagate labels"). I suspect that is easier than any other method I can think of right now Peter Jamieson > Thank you Peter. But is there any of the easier way. It will be a lot of > next record that I have to type. [quoted text clipped - 17 lines] >> > 25th line. In mail merge is there a way to skip a constant number of >> > lines? Did you see the response to your post on the same subject on August 17?  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 data file where fields in a record are listed one below the other > i.e. a record is not a line. Each record is made up of 50 lines. I need [quoted text clipped - 3 lines] > 25th line. In mail merge is there a way to skip a constant number of > lines? I think I would be inclined to convert the data file to a more usable format - see http://www.gmayor.com/convert_labels_into_mail_merge.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I have a data file where fields in a record are listed one below the > other i.e. a record is not a line. Each record is made up of 50 > lines. I need to extact the address to print labels. The address is > located every 20 through 25th line. In mail merge is there a way to > skip a constant number of lines? That is a good idea. Thank you. I will try to implement it. But I am wondering if Mail merge can say skip 'x' number of records. That way the data file can be used as is. > I think I would be inclined to convert the data file to a more usable > format - see http://www.gmayor.com/convert_labels_into_mail_merge.htm [quoted text clipped - 4 lines] > > located every 20 through 25th line. In mail merge is there a way to > > skip a constant number of lines? Back then to Peter's original suggestion of using 20 Next record fields (you can copy and paste them to save retyping). Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > That is a good idea. Thank you. I will try to implement it. But I am > wondering if Mail merge can say skip 'x' number of records. That way [quoted text clipped - 16 lines] >>> located every 20 through 25th line. In mail merge is there a way to >>> skip a constant number of lines?
|
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.