Mail merge dropping records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jan - 12 May 2004 15:42 GMT

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?

Reply to this Message

Jan - 12 May 2004 15:59 GMT

>-----Original Message-----
>I have a form with merge fields for first name, last name,
[quoted text clipped - 6 lines]
>
>FYI -- the database is an Excel document

Reply to this Message

Doug Robbins - Word MVP - 13 May 2004 00:00 GMT

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.

Signature

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

> I have a form with merge fields for first name, last name,
> SSN, DOB, that I want to merge with a database of about
[quoted text clipped - 3 lines]
> entry which solved the dropping the first record problem
> but did not solve dropping the others. Any idea?

Reply to this Message