Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-16-2011, 07:04 PM
macropod's Avatar
macropod macropod is offline Mail Merge - Filters adding condition not originally specified Windows 7 64bit Mail Merge - Filters adding condition not originally specified Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


Quote:
Originally Posted by bobcharest View Post
Do you think that Microsoft would be responsive to fixing the bug?
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]
Reply With Quote
  #2  
Old 12-16-2011, 07:23 PM
bobcharest bobcharest is offline Mail Merge - Filters adding condition not originally specified Windows XP Mail Merge - Filters adding condition not originally specified Office 2010 32bit
Novice
Mail Merge - Filters adding condition not originally specified
 
Join Date: Dec 2011
Posts: 6
bobcharest is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
Hi Paul, Thanks again for the help. I'm realizing (as I'm learning to insert the fields) that I don't think SKIPIF will work for me. I actually want the records that match both of my conditions to be present in the merged document so I can check our mailings. To skip the records where both conditions are met would give me the opposite of what I want I think. Am I wrong about this?

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
Reply With Quote
  #3  
Old 12-16-2011, 07:42 PM
bobcharest bobcharest is offline Mail Merge - Filters adding condition not originally specified Windows XP Mail Merge - Filters adding condition not originally specified Office 2010 32bit
Novice
Mail Merge - Filters adding condition not originally specified
 
Join Date: Dec 2011
Posts: 6
bobcharest is on a distinguished road
Default

Trying to initiate a bug report to Microsoft now...
Reply With Quote
  #4  
Old 12-16-2011, 08:26 PM
bobcharest bobcharest is offline Mail Merge - Filters adding condition not originally specified Windows XP Mail Merge - Filters adding condition not originally specified Office 2010 32bit
Novice
Mail Merge - Filters adding condition not originally specified
 
Join Date: Dec 2011
Posts: 6
bobcharest is on a distinguished road
Default 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.
Reply With Quote
  #5  
Old 12-17-2011, 01:06 AM
macropod's Avatar
macropod macropod is offline Mail Merge - Filters adding condition not originally specified Windows 7 64bit Mail Merge - Filters adding condition not originally specified Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by bobcharest View Post
Hi Paul, Thanks again for the help. I'm realizing (as I'm learning to insert the fields) that I don't think SKIPIF will work for me. I actually want the records that match both of my conditions to be present in the merged document so I can check our mailings. To skip the records where both conditions are met would give me the opposite of what I want I think. Am I wrong about this?
Hi Bob,

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]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge - Filters adding condition not originally specified Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
Mail Merge - Filters adding condition not originally specified check with condition karti Word 2 03-15-2011 06:06 AM
Mail Merge - Filters adding condition not originally specified 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft