Word 2003 merge from Access 2003 table

[Tom Toews]

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-]

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
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.

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