Cannot find access source for mail merge in word

[musicmike]

I have a word document that has a mail merge using an access database.

The problem is that everytime I open it up it says it cannot find the source for the mail merge.

Every time I point it to the database and save but it still doesn’t find it next time.

Any suggestions on what this could be?

 

[musicmike]

bump

 

[musicmike]

Bump

 

[mkirros]

What's the networking setup? Is the database on the same computer as the Word document, or is it on a server or another workstation? Also, what operating systems are you using, and what version of MS Office?

 

[musicmike]

Stand alone PC, Windows XP Pro and Office XP

 

[mkirros]

One more question (sorry) - Is the data source for the mail merge a table or a query? If it's a query, what type of query?

 

[musicmike]

All I can see is that it a select query. Hope thats what you meant.

Thanks.

 

[mkirros]

That's what I meant. Some types of queries don't work well with mail merges, but a regular select query shouldn't cause any problems. Do you have any calculated fields in the query, or are they all straight out of a table (or tables)?

 

[musicmike]

There are no calculations in fact only one table is used.

The only reason I used a query is because I couldn't get records to sort correctly with just using the table.

 

[mkirros]

I'm at a loss right now to explain why this would happen. Usually that type of message is related to a network issue, where the network connection has been lost. I'm still trying to see if I can figure it out, or cause the same error here.