Using skip record as well as if, then, else

azza · #1 10-11-2014, 05:37 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Transpose cells and skip?	ItsjustB	Excel	1	01-09-2013 08:53 AM
skip to next sentence?	moreenz	Word	3	08-16-2012 02:41 PM
Footer to Start on Page 1 - skip TOC	SQLUSA	Word	4	08-12-2012 11:36 AM
avoid duplicete record and merge the record with the existed record	hemant.behere	Excel	0	01-10-2012 02:53 AM
skip duplicate letters	karen h	Mail Merge	10	03-23-2011 08:37 AM