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
|