View Single Post
 
Old 10-11-2014, 05:37 PM
azza azza is offline Mac OS X Office 2008 for Mac
Novice
 
Join Date: Oct 2014
Posts: 4
azza is on a distinguished road
Default Using skip record as well as if, then, else

I have two requirements for my merge:

1. I want to skip null records
2. I want to include text in non-null records.

e.g. field "Boy4" is a number from a spreadsheet. If the field is null, I want to skip the record (to save space on my tickets) but if it's a number, I need to include text in front of the field like "Boys Aged Four: {MERGEFIELD Boy4}".

I seem to be able to do one or the other but not both - I'm not sure where I'm going wrong and I'd appreciate any help.
Reply With Quote