I have set up an excell database of approximately 30 fields in column form
which consists of the usual address, etc, detail and then about 20 field with
either a Y, or N to indicate whether they are applicable or not. Instead of
presorting the excell file, with the criteria of city and then relevant
fields which are applicable, is there anyway I can use the word to selective
say that if the city field = Ottawa (for example) to select that record and
then further, one of the 15 fields I have been selected have have a "y" it
would then select the record into the mail merge.

I have been trying to use the "insert word field" feature and specifically
the "skip record if" and "next record if", but am not having any luck.

Any other idea.