How do I get Word 2003 mail merge documents to save data source

[Jeff]

How do I get Word 2003 mail merge documents to save data source and record
selection information with the document? Every time I open a document I have
to tell Word where to get the data (Access file) and which records to select.
Maddeningly, about one in ten documents do 'remember' this information when
opened. What am I doing wrong? never had a problem with this in Office 2000.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?SmVmZkBwcGdjb25zdWx0aW5nLmNvbQ==?=,

How do I get Word 2003 mail merge documents to save data source and record
selection information with the document? Every time I open a document I have
to tell Word where to get the data (Access file) and which records to select.
Maddeningly, about one in ten documents do 'remember' this information when
opened. What am I doing wrong? never had a problem with this in Office 2000.

This is a problem with Word 2002/2003 + Excel/Access connections, usually, when
you've selected records using the Recipients dialog box and have an OLE DB
connection. Use an older connection method (DDE, like in 2000, or ODBC) and the
problem usually goes away. You'll find instructions on how to "roll back" in the
Word 2002 section of my website's mail merge FAQ.

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