skip records in mail merge

R

R Alapatt

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?
 
P

Peter Jamieson

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
 
R

R Alapatt

Thank you Peter. But is there any of the easier way. It will be a lot of
next record that I have to type.
 
P

Peter Jamieson

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
 
D

Doug Robbins - Word MVP

Did you see the response to your post on the same subject on August 17?

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

R Alapatt

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

Graham Mayor

Back then to Peter's original suggestion of using 20 Next record fields (you
can copy and paste them to save retyping).

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top