Mailmerge from Access Query - Data missing in Word

[shirl]

Hi

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

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

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

Hope someone can come up with a simple explanation.

Thanks
Shirle

 

[Peter Jamieson]

Yes, it can be confusing.

Is your query a "parameter query" (where the user has to provide the
value of one or more fields), or does it contain wildcards (LIKE
'something*'), user-defined functions (written in Access VBA), financial
series functions, or the "replace" function?

If so, let us know which - perhaps a simpler query would demonstrate the
specific thing you want to demonstrate (not sure what that is exactly)
without so many problems.

Peter Jamieson

http://tips.pjmsn.me.uk

 

[shirl]

Hi

It is just a simple Access query with the critera Like A* to find al
the postcodes which begin with A.

Shirley

 

[Peter Jamieson]

OK, there is unfortunately a problem with using wildcards in queries
being used by merge, because Access itself expects to use * for multiple
characters and ? for single charactes, but when Word 2002 or later gets
data from Access, it uses OLE DB which does not recognise * and ? but
wants to use % and _ instead.

The simplest thing to do in this case is probably to have two queries,
one with
Like 'A*'
for use within Access itself, and another with
Like 'A%'
for use by merge. Obviously, if you only have to present one of these to
students, life will probably be simpler...


Peter Jamieson

http://tips.pjmsn.me.uk

 

[shirl]

Peter

Thanks for the reply, a colleague has also found a similar response an
we will report it to the exam board, I suspect that whoever wrote th
exam paper did not test using a query for a mail merge.

Thanks for taking the time to reply
Shirl