[Cookie]

Thanks for the help Peter, I'll give it a try

"Peter Jamieson" wrote:

There are a few things you can consider as long as the number of records you
need per page is fixed, e.g.:

If your data source makes it reasonably easy to duplicate your data rows in
the pattern you need (i.e. so you have the first 8 rows, then repeat them,
then the next 8 rows, then repeat them) your best bet is definitely to
produce a modified version of your data source.

Otherwise, you can try the following. Imagine that you only needed to re-use
3 rows, and that you needed to reuse "fielda" and "fieldb". Then try the
following field code:

{ SET r1fa { MERGEFIELD fielda }
}{ SET r1fb { MERGEFIELD fieldb }
}{ NEXT
}{ SET r2fa { MERGEFIELD fielda }
}{ SET r2fb { MERGEFIELD fieldb }
}{ NEXT
} then use { REF r1fa } (or just { r1fa } to insert the value of fielda from
record 1, { REF r2fb } to isnert the value of fieldb from record 2, and {
MERGEFIELD fielda } to insert the value of fielda from record 3
then insert a page break
and use { REF r1fa }, { REF r2fb } and { MERGEFIELD } fields on the next
page.

You may find some things do not work, such as ADDRESSBLOCK fields (which are
usually best avoided anyway). But try it, and it may be enough for your
requirement.

-
Peter Jamieson
http://tips.pjmsn.me.uk

"cookie" wrote in message
...
..thanks Rich. I don't think I have explained the problem very well so
I'll
try again.
For an example: The first page of the letter will contain details from
the
first 8 records in the database, hence the use of 'next record' after each
mergfield. The second page requires exactly the same data to be taken
from
the same first 8 records in the database. The difference between the two
pages is purely in the added text. I have tried omitting the last 'next
record' on the first page to see if the merging proces will recognise the
request for data from the database as a new request for the second page
but I
still get the same result.


"Rich/rerat" wrote:

cookie,
Try removing the "Next Record" field from your document/template. If
the
information on page two, is identical to page one, you don't need that
field.

--
Have A Good Day
Rich/rerat

Add MS to your News Reader: news://msnews.microsoft.com
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate

"cookie" wrote in message
...
I am mail merging a 2 page letter. the first and second pages both
contain
exactly the same merge fields. ie first name, last name etc and refer to
the
same people in an Access database. When I attempt to merge the data to
the
letter the data transfers to the first page of the letter but not to the
second page. I am using the following method: first name last
nameNext
record
first name last nameNext record

I have tried formulating the two pages of the letter as separate
documents
and copying one document to the other but still get the same result.

I would be grateful for any help