Fill blank field with Customer?

[Ady]

Hi

I am merging from excel database into word. On one field in the excel
database I have a column called "contact name". however some of these are
blank (not all customers give out their name).

In my mail merge I shalll have Dear <customer name>. However when there is a
blank it will show up as blank on the mail merge letter.

Is there a method of inserting "Customer" in word document if <customer name

in database is blank. Do not want to be left with Dear..........

Many thanks is advance for any help offered. Please note I am a newbie, so
please reply in newbie language!!!!!

Many thanks again

Ady

 

[Greg Maxey]

Ady,

You need to use a conditional IF field:

Dear {If {MERGEFIELD contact_name} = "" "Customer" "{MERGEFIELD
contact_name}" }

You can do this with the Insert Word Field>If..Then..Else... menu item.
Leave the Compare to window blank, type Customer in the Insert Text Field,
and type {MERGEFIELD contact_name } in otherwise window. The { } must be
entered with CTRL+F9

 

[Ady]

Hi Greg

Thanks for this, just what I was looking for! Much appreciated!!!!!

Ady