[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

[Doug Robbins - Word MVP]

If the fields do not appear in the data source, you will either have to
delete them from the mail merge main document, or have a number of mail
merge main documents each with the one of the possible collections of fields
and then use the appropriate one for the merge.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"ntulley" wrote in message
...
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