You can see what's in all the fields by pressing Alt-F9 to toggles the field code display on/off.



The field coding I suggested already won't merge any record that has a 0 in column A.

Pressing Ctrl-F9 creates a set of field braces; it has nothing to do with viewing fields or auto-text. Moreover, embedding your content in an IF field has no effect on that content's formatting.

As for content changing every 14 days, you're going to have that issue whichever approach you take. You might even have a column in your workbook into which you can insert whatever that variable text is, so you can reference it via a mergefield instead of having to edit the mailmerge main document.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]