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
Last edited by shirl : February 12th, 2009 at 09:25 PM.
Reason: added comments re-2003
|