[Doug Robbins - Word MVP]

Is each record 50 lines as mentioned in your second posting, or 1510 lines
as mentioned in this one. It will make a difference to the code that you
will need in the macro.

--
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
...
Thank you for your response I did not get a notification, hence my entry
again.

My data source is a text file. Each record is 1510 lines. The address is
lines 110 to 115. When you say run a marco ( i am not familiar with
macro)
will it create another file with just the address info?



"Doug Robbins - Word MVP" wrote:

It is not really practical to try and do that simply with a mail merge.
It
would be far better to run a macro over the data source and extract the
necessary information.

What is the data source?

If it were a Word document, you may be able to use the Convert Text to
Table
facility under the Table menu to convert the data to a 24 column table
and
the insert a row at the top of the table and insert field names into that
row and then just insert the fields from the first five columns into a
mail
merge main document.

There are other ways, but the best way will be dependent upon the data
source.

--
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 that lists all the data one below the other. But
each
record is a constant number of lines. I need to pick up the address
which
is
on 5 lines starting every 25th line.