Put the street back in an Address Block

Make5 minutes

The problem

Your letters show the name and city, but no street line.

Word preview of a letter. It shows Ava Reed and Boston, MA 02108 with no street line between them. A hand-drawn circle marks the gap, and an arrow leads to the words street missing.

Why it happens

Address Block looks for columns with names it knows. In our test it matched Province and Postcode on its own, but not Street. So the street line was left out.

Fix it

  1. On the Mailings tab, click Address Block. In the box that opens, click Match Fields....

  2. Find Address 1. If it says (not matched), choose your street column, like Street.

  3. Check the other rows too, like State and Postal Code.

  4. Click OK twice. Click Preview Results and check a few people, including one with a long address.

In our test, matching Address 1 to Street brought the street line back.

Build the address lines in your list instead, then merge them as plain fields. Try Build a U.S. city-state-ZIP line or Keep a unit on the street delivery line.

The Match Fields box with Address 1 set to Street. Below it, the Word preview with 12 Main St back above the city line.

Watch for

On labels, the address lines can spread apart and get cut off. Select the label text and open Paragraph on the Home tab. Set Before and After to 0 pt and Line spacing to Single. Then, on the Mailings tab, click Update Labels.

For: Word for Windows

Microsoft's help: Match Fields · Insert mail merge fields