Mail merge dropping records

[Jan]

I have a form with merge fields for first name, last name,
SSN, DOB, that I want to merge with a database of about
100 records. There are five records per page. It merges
fine but drops every fifth record when I merge the entire
database. I deleted the "next record" code on the first
entry which solved the dropping the first record problem
but did not solve dropping the others. Any idea?

 

[Jan]

-----Original Message-----
I have a form with merge fields for first name, last name,
SSN, DOB, that I want to merge with a database of about
100 records. There are five records per page. It merges
fine but drops every fifth record when I merge the entire
database. I deleted the "next record" code on the first
entry which solved the dropping the first record problem
but did not solve dropping the others. Any idea?

FYI -- the database is an Excel document

 

[Doug Robbins - Word MVP]

Are you sure that you do not have a <<Next Record>> field after the last set
of merge fields on the page?

You should use either a label or a catalog (or in Word XP/2003 a directory
type) mailmerge main document. In the latter you would just use one set of
merge fields. If you want to force it to only insert 5 records per page,
arrange those fields inside a single cell table that has the cell dimensions
fixed so that only five of them will fit on a page.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP