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
|