Mailmerge filter parameters duplicate themselves

[Parish Pete]

I use several mailmerge docs in Word 2007 which feed from Access 2007
databases.

Where I use filters to edit recipients I have found that if there is more
than filter parameter, the last parameter is duplicated up to 3 times. The
resulting output is incorrect.

Even if I clear the filter and start again, the same thing happens. It is
not confined to any particular merge document or table.

In essence if I enter only 2 parameters, I get 5.

Any clues welcome

 

[Doug Robbins - Word MVP on news.microsoft.com]

Use an Access Query to do the filtering. It is much better to do the data
manipulation in a database than in a word processor.

--
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, originally posted via msnews.microsoft.com

 

[Parish Pete]

Use an Access Query to do the filtering. It is much better to do the data
manipulation in a database than in a word processor.

--
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, originally posted via msnews.microsoft.com




Doug,

Yes you are right and as a general rule I do. Occasionally I need to just
do something slightly different and the Word filter is the simple answer...
at least it would be if it worked properly.

The point I'm making is that what happens is acorruption of the filter
parameters.

If I filter on Column A ="yes" OR Column B is blank, what I end up with is
the first 2 plus 3 extra parameters of OR column B is blank. No matter what
I do it inevitably reverts to the few extra parameters.

Doing the task another way is not the way to cure the problem. It should be
easy and it should just work.

It doesn't do it every time, only when the second paramater is an OR
statement. ANDs are fine.

regards

pete

 

[Insomniac Ellis]

Use an Access Query to do the filtering. It is much better to do the data
Doing the task another way is not the way to cure the problem. It should be
easy and it should just work.

It doesn't do it every time, only when the second paramater is an OR
statement. ANDs are fine.

I've had similar problems and wondered if you'd found a solution. Both data
and filter are from 2007 versions of Office. The filters not only reproduce
but also add various other options, like "OR field='blank'" This happens with
simple AND queries not just OR as with yours. Did you find an answer or is
this an application error?