Hi,
I'm trying to merge from a large table and then use mail merge recipients
window to set up filtering of the table. This way I don't have to write a
query for each separate merge. The problem is that Word will not keep my
settings. It usually tries to add an or statement into the mix so I end up
getting a whole lot of records I don't want. For instance, with two fiels
<state> and <reply>, if I select <state> = "CA" and <reply> = blank, Word
will change this to <state> = "CA" and <reply> = blank or <reply> = blank.
Has anybody run into this problem and found a fix?
Thanks,
Tom
Cindy M -WordMVP- - 03 Dec 2003 18:52 GMT
Hi Tom,
Are you using the Recipients lists, or the "Advanced" Query Options dialog
box? What data type is the reply field?
Does the Access database use ANSI-89 or ANSI-92? And are you linking to it
using the (default) OLE DB or another connection method?
> I'm trying to merge from a large table and then use mail merge recipients
> window to set up filtering of the table. This way I don't have to write a
[quoted text clipped - 3 lines]
> <state> and <reply>, if I select <state> = "CA" and <reply> = blank, Word
> will change this to <state> = "CA" and <reply> = blank or <reply> = blank.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)