[ntulley]

Here are a few of my columns: NOSUB_Text, NOSUB_FALL, NOSUB_SPRING,
FSSL_Text, FSSL_FALL, FSSL_SPRING.

What I need to do is write an if statement that would allow me to skip one
of these fields and leave it blank if it is not present in the merge document.

Example: One day I might get all of these fields with information in it,
but the next day I will only get the NOSUB. So, I want Write and if statment
that would skip the FSSL fields.

I would have to write the statement for each one, so in general what would
it be?

{IF Missing{FSSL_Text} ""} ?????? The problem is, column will not show at
all in the spreadsheet if that student did not receive an FSSL award, but my
Mail Merge is set-up to catch both FSSL and NOSUB.

Thanks