Disappearing Access Queries in MSWord MailMerge

[McLiguori]

(Apologies if this is a repeat post. I tried to post it earlier, but it did not appear in the new posts window)

When I try to do a mail merge with MSWord XP, I select an access database for the source for my recipients. A dialogue box opens in which all my querries and tables appear. I can then choose which one I wish to use to create my recipient list. I created a new query to meet my criteria for recipients. The query works fine in Access. HOWEVER, when I try to mail merge, the new query does not appear in the list of querries and tables presented by MSWord. All the previously created ones appear and function properly, but not so with any new table or querry that I create.

Can someone please help me with this problem? Thanks.

McLiguori

 

[lameid]

It sounds like an order of events problem. Make your query first in Access and then try to do the merge in word. Word probably just reads the available object list once.

 

[McLiguori]

Thanks. I think I found the problem. I went into tools, options, then advanced, then set the Default File Format to Access 2002 (from the 2000 at which it was set) and all works just fine. I think it is an incompatibility problem Between Office XP or 2003 and Access 2000 file format.

Thanks Much!

Ligs