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

Hi optiontips,

See if any of the advice at:
http://office.microsoft.com/en-us/ac...001233657.aspx
or:
http://support.microsoft.com/kb/214183
applies.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Cross-posted at: http://www.techsupportforum.com/foru...rd-613764.html

For cross-posting etiquette, please read: http://www.excelguru.ca/node/7

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]