Problem getting all Access records to merge into Word.
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!
|