If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|