word 2000 mail merging access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M3cca - 23 Nov 2005 15:28 GMT

We have documents in word 2000 that use info from an Access database on a
server as the data source for mail merge. The datasources have been saved
with each document. One of the computers has Office Professional XP and has
no problem with the data source that is saved with each document. The other
two machines have word 2000. When you open the document the data source is
not there and you have to do the steps to open the data source and then
merge. Any one have any info as to why. I have tried everything I can think
of. We would like to not have to open the data source everytime. Any response
would be most grateful.

Reply to this Message

Cindy M -WordMVP- - 27 Nov 2005 10:05 GMT

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

> We have documents in word 2000 that use info from an Access database on a
> server as the data source for mail merge. The datasources have been saved
[quoted text clipped - 4 lines]
> merge. Any one have any info as to why. I have tried everything I can think
> of. We would like to not have to open the data source everytime.

Some versions/installations of Word have problems retaining data sources that
aren't saved locally. About the only *reliable* suggestion I can make would be
to put an AutoOpen macro in these documents that connects to the data source
if it's not available.

If you decide to go this route, you will need two sets of documents for the
Word 2000 vs. later versions. The object model for connecting a data source
changed slightly in Word 2002.

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