Mailmerge always grabs the first record in Access table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Darshan Khalsa - 03 Jan 2006 18:14 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 03 Jan 2006 19:18 GMT

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

Signature

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

> With Microsoft Word 2003 and Access 2003, when mailmerging a Word document
> that contains simple data fields and some query criteria selected, if
[quoted text clipped - 8 lines]
> Knowledge
> Base.

Reply to this Message