I have a customer database of about 850 entries (mainly first name, last name, address, suburb etc.) in an .mdb file. Currently using Access 2007 now and Word 2007.(Windows XP SP3)



I have created a dozen or so simple queries to extract different client profile information by using a criteria of a field = * (i.e. whatever I need such as suburb). The queries run fine in Access.

When I begin a Mail Merge wizard in Word I get to the point of the wizard where I would like to use a recipients list based on one of these queries. Problem is not ALL the queries are listed. I cannot work out any difference between the queries structure in Access. They all do not have the hide attribute.

I found some info on problems accessing .mdb (Access 2003 and earlier databases) over the newer accdb format. So I converted the mdb to accdb and re ran the merge process - no change.

Any thoughts would be appreciated.
Thanks in advance.
optiontips.in