Microsoft Office Forums - View Single Post - Mail merge how to link mail merge field value to a column heading

macropod · 05-08-2014, 02:59 PM

To do this, you would have to redesign your document so that each row in the sub-tables is a separate table in its own right and embed that one-row table in a field coded along the lines of:
{IF{MERGEFIELD Fig__Red_Wine}> 0 "|Fig & Red Wine|{MERGEFIELD Fig__Red_Wine}|"}
where the '{}' represent the field brace pairs and the '|' represents the left/right cell borders.

Along the same lines, if you want to suppress the headings also when all rows for a sub-table are empty, you'd need to embed that in a field coded along the lines of:
{IF{={IF{MERGEFIELD Fig__Red_Wine}= 0 0 1}+{IF{MERGEFIELD Rustic_French}= 0 0 1}+{IF{MERGEFIELD MultiSeed}= 0 0 1}+{IF{MERGEFIELD Focaccia}= 0 0 1}}> 0 "|Bread|"}