Mail Merge "if" statement

[Guest]

I have a merged document with multiple records on each page. I need the
formatting to remain the same throughout the page. I have lines for name,
address, home phone, bus phone, & email. If the business phone is blank in
excel, word is removing the line, thus messing up the formatting for the
record below. How do I make it put a blank line if the information is blank?
Im sure its an "if" statement but I can not figure them out. thx

 

[macropod]

Hi Patty,

If you select the problem mergefield and press Shift-F9, you should see its coding, which will look something like:
{MERGEFIELD Bus_Phone}
if there's a '\b' in the field, eg {MERGEFIELD Bus_Phone \b}, removing it may help.

Other than that, you could put the mergefields into a single-celled table with a fixed row height - or have a separate tab;e row for
each merge line. That way, the rest of the document's formatting won't change if some merge lines are empty.

No need for the complications of an IF test but, if you want one:
{IF{MERGEFIELD Bus_Phone}= "" "¶
" "{MERGEFIELD Bus_Phone}"}

Cheers