Question
-
Topic
-
Word 2003 Mail Merge with Excel – Advance Filter problems
LockedOn an XP system I set up a mailing label document in Word 2003 that uses an Excel spreadsheet as data source. In order to suppress certain rows, I used the “advance filter” option on the recipients list. Whenever I save the labels document, or even if I just open up the recipients list and click OK, spurious lines are added to the advance filter. If I repeat either of these actions, further spurious lines ae added to the filter. The spurious lines are such that the filtering condition does not do what I originally wanted it to do. For example, if I have a condition such as: “List Not Equal to ABC” the system adds “Or List Is blank”. I previously used this same labeling setup on a Windows 98 – Word 97 setup, and things worked fine. Thinking there might be a conversion issue, I re-built the entire label document from scratch, but it made no difference. Can anyone throw any light on this?