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
[quoted text clipped - 3 lines]
> 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
:-)