[Jay L.]

I'm having an issue where I am using an Access query to generate a mail merge
in Word. When I'm in Word, if I "edit recipient list" in the merge window, it
shows me that all 168 of my records are there. (These are simply name/address
type records).

However, when I run the actual merge, there are some 30 or so records that
do not appear in the merged document.

Can anyone tell me what would be causing this? It's driving me nuts!

[Doug Robbins - Word MVP]

Try one of the alternative methods of connection to the data source that
will become available after you select Options from the Tools menu in Word
and then go to the General tab and check the box for "Confirm conversions at
open".

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Jay L." Jay wrote in message
...
I'm having an issue where I am using an Access query to generate a mail
merge
in Word. When I'm in Word, if I "edit recipient list" in the merge window,
it
shows me that all 168 of my records are there. (These are simply
name/address
type records).

However, when I run the actual merge, there are some 30 or so records that
do not appear in the merged document.

Can anyone tell me what would be causing this? It's driving me nuts!

[Peter Jamieson]

Just a guess...

Does your Access query have any date literals in it, e.g. in the WHERE
clause?

e.g.

WHERE mydate #1/1/2007#

?

If so, I would try a version of the query that uses datevalue('2007-01-01')

I'd try Doug's suggestion, but
a. what is the SQL code of the query
b. do you have any records with double-quote characters in the data?

Peter Jamieson
"Jay L." Jay wrote in message
...
I'm having an issue where I am using an Access query to generate a mail
merge
in Word. When I'm in Word, if I "edit recipient list" in the merge window,
it
shows me that all 168 of my records are there. (These are simply
name/address
type records).

However, when I run the actual merge, there are some 30 or so records that
do not appear in the merged document.

Can anyone tell me what would be causing this? It's driving me nuts!