![]() |
#1
|
|||
|
|||
![]()
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
|
#2
|
||||
|
||||
![]()
The SKIPIF field for that would be coded as:
{SKIPIF{MERGEFIELD PrintLable}= ""} or: {SKIPIF«PrintLable»= ""} Note: The field brace pairs (ie '{ }') for the above examples are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practicable to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. Note also the required space after the '='.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
bertietheblue | Word VBA | 4 | 11-03-2013 04:56 PM |
![]() |
rmw85 | Word Tables | 3 | 10-11-2012 06:02 PM |
Unwanted border created when entering print preview and printing slides | jcameron | PowerPoint | 2 | 10-02-2012 07:16 AM |
![]() |
moreenz | Word | 3 | 08-16-2012 02:41 PM |
![]() |
judicial85 | Excel | 1 | 10-23-2011 01:35 PM |