Forum Discussion
Word Mail Merge Filter Issue
Carl -- I'm going to just give you a work-around, rather than try to slog through that full description. Having just gone through using Mail Merge to create mailing labels for Christmas cards...one thing I did there (and I'm suggesting you do) is print to a file. You could just print to PDF and delete the pages you don't want. It's not a real solution, but it'll work if you don't have time to come up with the real solution.
Thank you for your reply. Sounds good. However, just trying to realize why the filter is producing the issue I am having. Is Microsoft aware of this issue? Is this a known issue. If so, what are they doing about it. Blah, Blah, Blah........
"Just delete the pages you don't want" is a fine suggestion... If one knew what pages (from thousands) one didn't want.. without using a filter expression (some of the field's I'm filtering on aren't even in the output document). My work around was to resort to creating a "filter" in excel (a sheet that somewhat painfully "filters" data from the sheet I would otherwise use). Its awful, and "contaminates" the workbook. Carl_61 - I don't know what I've done differently today to have this problem, but I have other word docs filtering data from excel workbooks and they are working (and now I'm afraid to touch them) ... This one is being weird - and I don't know why.. Exactly the problem you describe ("OR" <a field in my data> "is blank" ) clause added without my asking for it.
