For any who follow me, I worked out a work around.
Don't use filters or advanced options to show if blank.

I added a field to the mail merge to Skip is the field is not blank (ie
print if blank)

I guess Word/excel has a problem reading data with only blanks set, but
word by itself can sort out the problem.

I then went on the add more of the static filters as Skip if, making
the whole process simply to run each month.


--
AYager