tdawg
Platinum Member
Hi All,
So, I'm getting a little aggravated and before I harm my workstation, I figured I'd solicit the community's help.
I have an Excel 2007 spreadsheet of contact information and such, along with a Word 2007 document for an email merge that is pulling the recipient list from the Excel document. I'm trying to filter the list of recipients to two conditions, but Word dumbly wants to insert a third condition that negates the other two.
Here's a screenshot of the filter rules: http://picasaweb.google.com/tr...wE#5356225161425880050
The problem is, I am only defining the first two rules - NVP Needed = Yes and Date Email Sent? = Is Blank. However, when I close the dialog box and go back to the document, Word adds the third rule, Or Date Email Sent = Is Blank, which negates the requirement that NVP Needed must be Yes.
Does anybody know why Word is trying to add this third rule and how I can get rid of it? I've cleared the filters, closed the dialog box, saved the document and closed it, opened it back up, added the two conditions, closed the dialog box, opened the conditions window again and the third rule is back!
Any help is appreciated. I'm about to go crazy.
Thanks,
Trevor
So, I'm getting a little aggravated and before I harm my workstation, I figured I'd solicit the community's help.
I have an Excel 2007 spreadsheet of contact information and such, along with a Word 2007 document for an email merge that is pulling the recipient list from the Excel document. I'm trying to filter the list of recipients to two conditions, but Word dumbly wants to insert a third condition that negates the other two.
Here's a screenshot of the filter rules: http://picasaweb.google.com/tr...wE#5356225161425880050
The problem is, I am only defining the first two rules - NVP Needed = Yes and Date Email Sent? = Is Blank. However, when I close the dialog box and go back to the document, Word adds the third rule, Or Date Email Sent = Is Blank, which negates the requirement that NVP Needed must be Yes.
Does anybody know why Word is trying to add this third rule and how I can get rid of it? I've cleared the filters, closed the dialog box, saved the document and closed it, opened it back up, added the two conditions, closed the dialog box, opened the conditions window again and the third rule is back!
Any help is appreciated. I'm about to go crazy.
Thanks,
Trevor