Missing merge data in new document

[Katie Hayden]

After creating a main mail merge document in Word, using
Access 2003 as the database, I review the "view merged
data" and all mail merge recipients are viewable. When
I "merge to a new document" not all recipients are merged
even though ALL are selected in "mail merge recipients".
There's no consistency to which data gets pulled into the
new document.

 

[Cindy M -WordMVP-]

Hi Katie,

Default OLE DB connections with Access and Excel do
sometimes manifest problems. See if this helps:

Tools/Options/General, activate "Confirm conversions on
open".

Now link up to the Access database again. This time, you'll
get a list of available connection methods. Try ODBC. If
you're linking to a query, click "Options" and activate
"Views" to append a list of queries to the list of tables.
Select the data table/query.

After creating a main mail merge document in Word, using
Access 2003 as the database, I review the "view merged
data" and all mail merge recipients are viewable. When
I "merge to a new document" not all recipients are merged
even though ALL are selected in "mail merge recipients".
There's no consistency to which data gets pulled into the
new document.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail