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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff@ppgconsulting.com - 03 Mar 2005 00:35 GMT

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.

Reply to this Message

Cindy M -WordMVP- - 22 Mar 2005 22:00 GMT

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

Reply to this Message