Mail merge keeps asking for data source

[Lucas]

I have created a word document in word 2000 for mail
merge. This datasource points to a query in MS Access
2000. In Access 2000 i have written code to open the word
document. This worked perfectly in the 97 version. When
i hit the button to open the document, it keeps asking me
for a datasource name. The datasource already exists. I
don't know why it does this? Any suggestions?

 

[Cindy M -WordMVP-]

Hi Lucas,

I have created a word document in word 2000 for mail
merge. This datasource points to a query in MS Access
2000. In Access 2000 i have written code to open the word
document. This worked perfectly in the 97 version. When
i hit the button to open the document, it keeps asking me
for a datasource name. The datasource already exists. I
don't know why it does this?

Could you copy and paste the code into a reply, please? And
just to confirm: this is Office 2000 and not 2002? (There
would definitely be a problem in the latter case, but not
usually in the former.)

In addition:
- open the main merge document in question "manually". Do you
get the same message?

- if yes, rename Normal.dot to NormalOLD.dot. Restart Word.
In the new document that's displayed, connect to the data
source and set up a small test document. Save, close,
re-open. Do you get the same message, or none?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
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