Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-14-2014, 10:29 AM
jp91306 jp91306 is offline Entering proper syntax to SKIP unwanted Records Windows 7 64bit Entering proper syntax to SKIP unwanted Records Office 2007
Novice
Entering proper syntax to SKIP unwanted Records
 
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
  #2  
Old 04-14-2014, 03:15 PM
macropod's Avatar
macropod macropod is offline Entering proper syntax to SKIP unwanted Records Windows 7 32bit Entering proper syntax to SKIP unwanted Records Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
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

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



Similar Threads
Thread Thread Starter Forum Replies Last Post
Entering proper syntax to SKIP unwanted Records Macro to highlight 100s of proper nouns bertietheblue Word VBA 4 11-03-2013 04:56 PM
Entering proper syntax to SKIP unwanted Records Proper way to calculate tables in document 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
Entering proper syntax to SKIP unwanted Records skip to next sentence? moreenz Word 3 08-16-2012 02:41 PM
Entering proper syntax to SKIP unwanted Records Proper Excel Table of Contents (ToC) judicial85 Excel 1 10-23-2011 01:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:55 AM.


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