![]() |
|
#1
|
||||
|
||||
![]() 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] |
#2
|
|||
|
|||
![]() 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 |
#3
|
|||
|
|||
![]()
Trying to initiate a bug report to Microsoft now...
|
#4
|
|||
|
|||
![]()
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. |
#5
|
||||
|
||||
![]() 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] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
sedain121 | Mail Merge | 2 | 10-04-2011 07:52 PM |
![]() |
karti | Word | 2 | 03-15-2011 06:06 AM |
![]() |
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 |