Mailmerge always grabs the first record in Access table

[Darshan Khalsa]

With Microsoft Word 2003 and Access 2003, when mailmerging a Word document
that contains simple data fields and some query criteria selected, if there
are for example 3 Access records meet the criteria, then the resulting merged
Word document includes the first record in the Access database (instead of
the first record that meets the query criteria) and the second and third
records in the Access database that do meet the query criteria. This seems to
be a bug in Word's mailmerge process not mentioned in the Microsoft Knowledge
Base.

 

[Doug Robbins - Word MVP]

Use an Access Query to select the records that you want to merge and as the
datasource for the mailmerge.

--
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