#1
|
|||
|
|||
Mail Merge - Filters adding condition not originally specified
This worked correctly in my previous version of office (2003)
I'm creating mail merge documents using an Excel doc as the data source. In Word, when I specify the following criteria for fields and conditions: Mailed is blank and Print equal to X then click on OK to close the dialog, Word creates the following: Mailed is blank or Mailed is blank and Print equal to X This invalidates the conditions I originally specified, as there are many entries where the Mailed field is blank and I testing for the originally specified set of conditions only. This bug is reproduceable - should I go to Microsoft with it in some way? Thanks in advance, Bob Charest |
#2
|
||||
|
||||
Hi Bob,
I've seen this reported before, but I've not seen a solution. As a workaround, you could abandon the filter and use SKIPIF fields in the document, coded along the lines of: {SKIPIF {MERGEFIELD Mailed} = ""} and: {SKIPIF {MERGEFIELD Print} = "X"} Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Hi Paul,
Thanks for the workaround. As this one case is my test to see what labels we might have printed but not mailed, I can try to implement the SKIPIF fields. I haven't coded fields like that into a document previously, so this will be an experiment on my part. Do you think that Microsoft would be responsive to fixing the bug? That's what I would really like to do. Thanks for your reply, and I'll post how I make out... if I can do it If not, I'll ask more questions. Best regards, Bob Charest |
#4
|
||||
|
||||
I hope so, it's a fairly significant issue for some users and seems related to testing for blanks - AFAIK the rest of the filtering works OK, in which case you could leave the Print filter in place and just use the SKIPIF test for the Mailed field.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Quote:
When we print these labels I'm testing for the presence of other non-blank fields in addition to the print field. This give us labels for business associates, clients, personal aquaintances, etc. I agree that the problem seems to be related to testing for blanks, as after the field that has been tested for "is blank" the software inserts an "or" operand, invalidating the argument. Thanks again, Bob Charest |
#6
|
|||
|
|||
Trying to initiate a bug report to Microsoft now...
|
#7
|
|||
|
|||
Transcript Of Chat with Microsoft Answer Desk
OK, so I initiated a report of this bug to Microsoft - here's a transcript of the chat session:
Welcome to Answer Desk. Kxxxx Sxxxx [09:36 PM] : Hello and welcome to the Microsoft Answer Desk! My name is Kxxxx Sxxxx . How may I help you today? Bob [09:37 PM] : hi Kxxxx, I'm trying to report a bug to microsoft in word 2010 relating to mail-merge filters Kxxxx Sxxxx [09:39 PM] : a bug? Bob [09:39 PM] : Specifically, when a field is tested for "is blank" word inserts another statement with an "or" operand invalidating the constructed argument. This problem is reproduceable Bob [09:40 PM] : Sorry, I didn't see your response! Yes, a bug. Bob [09:40 PM] : If there's another place to initiate this report, i'm happy to do so, just let me know, OK? Kxxxx Sxxxx [09:42 PM] : alright, thanks for reporting that. Bob [09:43 PM] : Is that all there is to it? I'd love to get it fixed. Is there any follow-up to the customer on this sort of thing? Kxxxx Sxxxx [09:44 PM] : No, we can find a tech who can remotely fix this, but there is a fee of $99. Kxxxx Sxxxx [09:47 PM] : would you like me to find a tech who can help? Bob [09:47 PM] : Kxxxx, as the problem is in all copies of the software that I own, and is a reproduceable bug wouldn't it need to be fixed in a kb for the product? Also, as a customer, the idea of paying Microsoft $99 to fix a problem that they have in a product that they sold is not acceptable to this customer... This is not a usability or end-user error. I have used Microsoft for OS crashes and such in the past, but that's a very different issue than a customer reporting a bug. Bob [09:48 PM] : In any case, am I correct in understanding that there is no further communication intended from Microsoft to me on this bug report? Kxxxx Sxxxx [09:49 PM] : correct Bob [09:52 PM] : Can you tell me what happens to the report I gave to you about the problem? I'm just trying to understand the nature of this communication channel and its effectiveness. Kxxxx Sxxxx [09:55 PM] : It will be forwarded to the support team, and they will be looking into the issue Bob [09:57 PM] : Great - thanks for your time, and hopefully Microsoft will be able to come out with a fix for this - I would appreciate that, and probably there are others using the product that would as well. Kxxxx Sxxxx [09:58 PM] : No problem. Bob [09:58 PM] : OK, goodnight and Happy Holidays! Kxxxx Sxxxx [09:58 PM] : happy holidays to you too Last edited by bobcharest; 12-16-2011 at 09:39 PM. |
#8
|
||||
|
||||
Quote:
With a 'Print = X' filter, only the records that have the 'X' would be passed through to the SKIPIF field for 'Mailed' testing. Conversely, with a 'Print <> X' filter, only the records that lack the 'X' would be passed through to the SKIPIF field for 'Mailed' testing. The 'Mailed' SKIPIF test can then be based on the presence or absence of something in that field, via: {SKIPIF {MERGEFIELD Mailed} = ""} or: {SKIPIF {MERGEFIELD Mailed} <> ""} FWIW, if you want to test for multiple conditions using just a SKIP field, you can code the field along the lines of: {SKIPIF{={IF{MERGEFIELD Mailed} = "" 1 0}*{IF{MERGEFIELD Print} = "X" 1 0}> 0} and: {SKIPIF{={IF{MERGEFIELD Mailed} = "" 0 1}*{IF{MERGEFIELD Print} = "X" 0 1}> 0} etc if both conditions must be met, or: {SKIPIF{={IF{MERGEFIELD Mailed} = "" 1 0}+{IF{MERGEFIELD Print} = "X" 1 0}> 0} and: {SKIPIF{={IF{MERGEFIELD Mailed} = "" 0 1}+{IF{MERGEFIELD Print} = "X" 0 1}> 0} etc if either condition must be met.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
||||
|
||||
Hi Bob,
An interesting discussion with MS Tech Support! Unless your copy of Office isn't fully updated, I very much doubt that any MS Tech could actually 'fix' it. For your $99, at best they might give a different workaround (eg coding the filters with vba, which is entirely do-able), but that's not a fix. And, given that it's a software fault (reported elsewhere in discussion groups), you shouldn't be charged for it.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#10
|
|||
|
|||
Quote:
My copy is at the latest fix level, and I couldn't agree more. While the person on the other end of the chat might have been more helpful for an actual "end-user" type question, the responses were sparse, it seemed. Between the $99 charge which would not have changed the release of the software and the somewhat dis-interested tone of the responses, the image of Microsoft as being unconcerned with the actual quality of the product was re-inforced for me. But, the general public has been the beta test group for many years now. I'm going to test the coding examples that you were so kind to provide and post results. I really appreciate your help! Best regards, Bob Charest Last edited by bobcharest; 12-17-2011 at 09:47 PM. |
#11
|
|||
|
|||
Word 2002 had that bug and so does Word 2013.
Word 2002 (XP) had the bug Bob Charest describes and today I see it again on my shiny new licensed and fully updated copy of Word 2013. My source data is in an Excel spreadsheet.
I've been Bingin' on the Internet but haven't found a solution yet, just workarounds. I appreciate the help from those who have suggested workarounds but I would like the root cause found and fixed. A workaround will only have me wondering "Why did I do this strange thing?" a month from now. |
#12
|
||||
|
||||
Cross-posted at:
http://answers.microsoft.com/en-us/o...=1402725563033 http://answers.microsoft.com/en-us/o...b-62a49aacf04a For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184 It seems you more interested in making a fuss about this than to contributing anything to resolving the problem. Please don't resurrect old threads just to have a whinge.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Saving INDV mail merges During the mail merge | sedain121 | Mail Merge | 2 | 10-04-2011 07:52 PM |
check with condition | karti | Word | 2 | 03-15-2011 06:06 AM |
Formula in a Cell with condition? | Learner7 | Excel | 1 | 07-19-2010 10:10 AM |
Retrict Method Condition | markp | Outlook | 0 | 12-22-2005 05:38 PM |
Junk mail Filters of Outlook 2003 | RoscoeL | Office | 0 | 11-24-2005 12:33 AM |