Answered by:
Office 2007 Mail Merge Filter Glitch

Question
-
The MS Office 2007 Mail Merge Filter automatically adds an "or" component that causes the filter to fail.
If I set "Field" "Is not blank" as a criterion. It works. But if I add and "AND" such as "AND" "Field" "Not equal to", the system automatically adds and "Or" "Field" 'Is blank" then my filter fails.
Thanks in advance for any suggestions or comments on using the Filter of Microsoft Mail Merger of Word 2007 with the Mail Merge Filter feature.
-- L. James
--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames
Saturday, August 28, 2010 7:04 PM
Answers
-
Hi,
Check the issue by starting Word with /a switch.
In Windows Vista and Windows 7
1. Exit Word 2007
2. Click Start
3. In the Start Search box, type the following text, and then press ENTER:
"%programfiles%\microsoft office\office12\winword.exe" /aIn Windows XP
1. Exit Word 2007
2. Click Start, and then click Run.
3. In the Open box, type the following text, and then press ENTER:
"%programfiles%\microsoft office\office12\winword.exe" /aIf this issue does not occur when starting Word using /a switch, we can try to rename the Word Global Template:
1. Exit all Office programs.
2. Click Start, click Run, type cmd, and then click OK.
Note: If you are using Windows Vista or Windows 7, click Start, in the Search box, type command prompt. right click on command prompt and choose run as administrator.
1. Type the following command, as appropriate for the version of Word that you are running, and then press ENTER:
ren %userprofile%\Application Data\Microsoft\Templates\Normal.dotm OldNormal.dotm
1. Type exit, and then press ENTER.
However, if the problem persists after this, we might need to repair the Office program from Control Panel > Programs and Features, right click the Office program and choose Change, then Repair
Best Regards,
Sally Tang
- Marked as answer by Sally Tang Friday, September 3, 2010 7:12 AM
Tuesday, August 31, 2010 7:13 AM
All replies
-
Hi,
Check the issue by starting Word with /a switch.
In Windows Vista and Windows 7
1. Exit Word 2007
2. Click Start
3. In the Start Search box, type the following text, and then press ENTER:
"%programfiles%\microsoft office\office12\winword.exe" /aIn Windows XP
1. Exit Word 2007
2. Click Start, and then click Run.
3. In the Open box, type the following text, and then press ENTER:
"%programfiles%\microsoft office\office12\winword.exe" /aIf this issue does not occur when starting Word using /a switch, we can try to rename the Word Global Template:
1. Exit all Office programs.
2. Click Start, click Run, type cmd, and then click OK.
Note: If you are using Windows Vista or Windows 7, click Start, in the Search box, type command prompt. right click on command prompt and choose run as administrator.
1. Type the following command, as appropriate for the version of Word that you are running, and then press ENTER:
ren %userprofile%\Application Data\Microsoft\Templates\Normal.dotm OldNormal.dotm
1. Type exit, and then press ENTER.
However, if the problem persists after this, we might need to repair the Office program from Control Panel > Programs and Features, right click the Office program and choose Change, then Repair
Best Regards,
Sally Tang
- Marked as answer by Sally Tang Friday, September 3, 2010 7:12 AM
Tuesday, August 31, 2010 7:13 AM -
I experienced the same problem as described by the OP, but in Excel 2016. In other words, the problem remains. Based on troubleshooting, I believe it is a coding bug. Repairing the installation did not fix it.
However, I was able to find a workaround. I used the condition "Does not contain" rather than "Is not blank," and magically the filter worked as it should.
Friday, September 29, 2017 4:49 AM -
I experienced the same problem as described by the OP, but in Excel 2016. In other words, the problem remains. Based on troubleshooting, I believe it is a coding bug. Repairing the installation did not fix it.
Cheers
Paul Edstein
[MS MVP - Word]Friday, September 29, 2017 5:09 AM