View Single Post
 
Old 04-14-2014, 10:29 AM
jp91306 jp91306 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Nov 2012
Posts: 16
jp91306 is on a distinguished road
Unhappy Entering proper syntax to SKIP unwanted Records

I have been printing labels using a simple Mail Merge...just printing Name, Address, etc. I WANT to set the merge so that ONLY records with a 1, or a "yes", or any other True/False type entry in a named column (PrintLable). I don't care how this column gets marked...whatever will make it print when wanted and skip when not. I can't seem to get any syntax correctly entered. Of course by default each label after the first label already contains a "NextRecord" field. I have tried to get NextIf and SkipIf to work, but nothing seems to be correct, so I am not getting the syntax correct, I assume. I always get all the records no matter how I enter the field. (We are using this on two different versions of Office...7 and 10, but I can set it up for each, if that is needed. Entering the instructions isn't the issue, just doing it correctly, is.) Could certainly use some guidance here. Thanks, jp
Reply With Quote