Hi,

I'm doing a mail merge on Word with a database from Excel (version 2007) and there is a set number of fields that I'm getting data in for the letters I'm creating.

The issue is that for some of the letters/people, some fields don't really apply... so can I create a rule for blank fields (whenever blank or "0") so it ommits those irrelevant fields for a given person?

Say we had a table with scores:

Math - 86

English - 64

Arts - blank/0 (because it's not applicable to this specific person, but can be for other people in the merge letter)

Physics - 92

Can we have the field "Arts" being fully ommitted and "Physics" coming after "English"?

How can I do this on word through the rules?

Thanks in advance,

Claudia