Mailmerge from Access Query - Data missing in Word

Hi

I am using Office 2007. I have a simple database which contains about 20 records. Have created a query to find people who live in a certain area. This query is then required to be merged to a Word document. I have tried doing this straight from access and I have also tried from Word using the mailmerge wizard.

Which ever method I use I when I tell it to use the query the data in the query is missing when in Word. I found another message in this forum which is similar and suggests using a make "table query" will get over the problem, however, this is for an exam for students and they must use the query for the mailmerge.

I have also tried using the word advanced options "Confirm File Format on Open", this does work but is very confusing for the students.

A colleague has also tried to use to do the same in Office 2003 and it does not work in that either

Hope someone can come up with a simple explanation.


Thanks
Shirley