Fix "Dear ," when a first name is blank

Make5 minutes

The problem

Some letters say “Dear ,” with no name after it.

A Word preview of a letter that reads Dear with nothing after it. A hand-drawn circle marks the spot, and an arrow leads to the words no name here.

Why it happens

Word prints whatever is in the first name column. When a row has no first name, the letter says "Dear ," with nothing in between.

Fix it

  1. In your letter, click right after "Dear " and before the first name field.

  2. On the Mailings tab, click Rules, then If...Then...Else.

  3. Set Field name to your first name column, and Comparison to Is blank.

  4. In Insert this text, type the word to use when the name is missing, like colleague. Leave Otherwise insert this text empty. Click OK.

  5. Click Preview Results. Check a row with a blank first name, then a row with a name.

Rows with a name still say "Dear Alex," and blank rows now say "Dear colleague,". Use whatever word fits your letter.

Build the greeting in your list instead, then merge it as one field. Try Make a Dear first name greeting or Make a Dear Title Last Name greeting.

A Word letter reads Dear with no name. The IF box inserts colleague when FirstName is blank. The preview then says Dear colleague.

Watch for

A first name that's only a space may or may not count as blank. It depends on how Word connects to your list. Clear those spaces in your list first, then preview a few rows. The Excel template Remove extra spaces from names does it.

Tested in: Word for Windows and Mac

Microsoft's help: Set the rules for a mail merge · IF field