View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cal Cal is offline
external usenet poster
 
Posts: 7
Default Merge is changing filter fields - without my asking it to

Okay...I think I may have found an actual workaround. Do not use the
Comparison field of "Not equal to." You will have to figure out the logic to
exclude the results you do not want - it will probably involve a set-up of
filters grouped by an "OR" with another very similar set-up of filters with a
minor variation. Just avoid the "Not equal to" option. It's brilliant when
it works, but in this particular case as soon as you use "Not equal to" all
havoc wreaks loose. Once you remove this type of Comparison from your Filter
Records tab of the Filter and Sort dialog box, the "ghost" filters that
Microsoft Office Word 2003 creates will not occur.

"Cal" wrote:

Has anyone run into problems with Microsoft Word 2003 where as you are
setting the filter fields for a mail merge, it is adding filter fields with
an "or"(and) header? It seems to be associated with a comparison field of
"Not equal to," though it will add filter fields if you have a bunch of "And"
settings followed by an "Or" setting. I've used these successfully in the
past (without filter fields being added) and am not sure if a recent
update/download jacked things up. I've cleared the filter fields completely,
started from scratch, and even tried to save the document with the correct
filter fields, but for whatever reason, those "ghost" filter fields get added
and by doing so, mess up my merge results. If anyone has any suggestions,
please let me know!