Mail Merge: Not seeing all queries

[jkb17]

Hello,

I have setup a mail merge with MS Word. I have Office XP installed. Problem is that my query is a query of a query. I know I have done this before but when I moved the document and db to a local machine (to make edits\development adjustments) I cannot see the "queried query" as an option in the "Select data source..." I can only see live tables and queries off of tables.

I know that I was able to create a merge off of a queried query. Does anyone know how to get around this?

Jim

 

[grnzbra]

I'm not really sure of what your problem is so I can't come up with an "official" solution. However, since you say you can see tables, a workaround might be to have the queries you can see create a temporary table and use that instead.

 

[kw2oak]

I have had a similar experience to this.

With XP and Office 2003 If you open word and tick 'Confirm Conversion on Open' when you set-up a mail merge you will be prompted by a dialogue box where you must choose whether you want to use DDE as your connection - if you choose to use DDE then you will be given the old-style mail merge dialogue that offers-up queries.

Hope this works - it did for me!!