Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge filter parameters duplicate themselves
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge filter parameters duplicate themselves
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" wrote in message ... 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge filter parameters duplicate themselves
"Doug Robbins - Word MVP on news.microsof" wrote: 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" wrote in message ... 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, 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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge filter parameters duplicate themselves
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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text looks different in doc, but all parameters the same | Microsoft Word Help | |||
hyperlink with parameters? | Microsoft Word Help | |||
Starting word with parameters | Microsoft Word Help | |||
right margin shifts beyond ruler parameters | Microsoft Word Help | |||
how do i change execution parameters | Microsoft Word Help |