Query will not display in Word

M

Mauzer

I have created a query in Access with the data I need for a mail merge. I
have run the query and the data displays in Access. When I browse to the
database to create the mail merge the query I have created is not displayed.
 
B

Big Mac

I have the same problem but I have noticed that it is a parameter query. All
other queries show up
 
P

Peter Jamieson

You are correct that Word 2002/2003 do not "see" some query types such as
parameter queries. In most cases, the simplest workaround is to check Word
Tools|Options|General|"Confirm conversion at open", then go through the
connection process again and choose the DDE option when it is offered.
You'll need to have a copy of Access on the machine where you're performing
the merge to do that.

Peter Jamieson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Append Crosstab Query to Existing Table 0
Some mail merge fields not pulling into document 2
Descenders clipped 0
Mail Merge - displaying a conditional number of decimals 5
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Help creating a search form in Access XP 0
add mergefields to exsting word 2013 2

Top