Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
R Alapatt R Alapatt is offline
external usenet poster
 
Posts: 6
Default skip 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?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default skip records in mail merge

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 Alapatt" wrote in message
...
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?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
R Alapatt R Alapatt is offline
external usenet poster
 
Posts: 6
Default skip records in mail merge

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

"Peter Jamieson" wrote:

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 Alapatt" wrote in message
...
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?




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default skip records in mail merge

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

"R Alapatt" wrote in message
...
Thank you Peter. But is there any of the easier way. It will be a lot of
next record that I have to type.

"Peter Jamieson" wrote:

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 Alapatt" wrote in message
...
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?






  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default skip records in mail merge

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 Alapatt" wrote in message
...
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?





  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default skip records in mail merge

I think I would be inclined to convert the data file to a more usable
format - see http://www.gmayor.com/convert_labels...mail_merge.htm

--

Graham Mayor - Word MVP

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


R Alapatt wrote:
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?



  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
R Alapatt R Alapatt is offline
external usenet poster
 
Posts: 6
Default skip records in mail merge

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.

"Graham Mayor" wrote:

I think I would be inclined to convert the data file to a more usable
format - see http://www.gmayor.com/convert_labels...mail_merge.htm

--

Graham Mayor - Word MVP

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


R Alapatt wrote:
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?




  #8   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default skip records in mail merge

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

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


R Alapatt wrote:
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.

"Graham Mayor" wrote:

I think I would be inclined to convert the data file to a more usable
format - see http://www.gmayor.com/convert_labels...mail_merge.htm

--

Graham Mayor - Word MVP

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


R Alapatt wrote:
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?



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
Can't get Word 2003 to keep data file with mail merge main documen Yourcareercoach Mailmerge 9 August 10th 06 12:19 PM
Mail merge put in extra records Mark Christensen Mailmerge 2 July 3rd 06 12:53 PM
Envelope Mail Merge from .xls all records rather than selection Kara Mailmerge 3 February 7th 06 06:59 PM
Cannot edit Access records from Word mail merge toolbar button Snazbaz Mailmerge 2 January 24th 06 07:17 PM
Saving Mail Merge Records & also printing them. Glenn Mailmerge 4 September 2nd 05 02:12 PM


All times are GMT +1. The time now is 04:23 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"