Mail merge field to show blank if it contains certain text

[kidwispa]

Hi,

I don't even know if this is possible but I hope someone can help me.

What I am trying to achieve is for a particular field (in this case Company Name) to show as blank when running a mail merge if it contains a particular term ("Residential")

Can anyone help?

Thanks in advance

 

[igold]

Hi,

In Word 2010, go to the "Mailings" Tab, look in the "Write & Insert Fields" section, and then look at the "Rules" dropdown box. You should be able to take it from there (you'll want to use the "If...Then...Else" rule).

igold

 

[Macropod]

You could use a filed coded as:
{IF{MERGEFIELD Company_Name}<> "Residential" {MERGEFIELD Company_Name}}
or:
{IF«Company_Name»<> "Residential" «Company_Name»}

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practicable to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. The spaces represented in the field construction are all required.