When you do mail merges, especially those involving addresses, some people have apartments and some don't.
If you are using an Address2 field in the address block, you need to hide that line if it’s empty.
Here’s how to hide any line. Let's assume here that the database I'm using for the mail merge is called nameslist_newcustomers.odb, that the table I'm using is just called Sheet1, and the address 2 field is called, well, Address2.
Get the mail merge document ready, with all the fields brought in. Be sure that you have the Address2 field, or the field you want to hide, on a line of its own, since the whole line, i.e. everything in that paragraph, will be hidden.
Click to the left of the Address2 field. (You can click anywhere on the line, but it’s simpler to always do it one way.)
Choose Insert > Fields > Other.
Click the Functions tab, then select Hidden Paragraph.
Type the following; the fieldname that might be empty is the fieldname you want to specify. This means everything on that line will be hidden if that field is empty:
You won’t see anything appear; it will look like the picture below.
If you want to prove to yourself it’s there, click to the right of the Address2 field, press the left arrow once, and press space three times. You’ll see there are two fields, the hidden paragraph field and the regular Address2 field as shown on the right. Now press Backspace again three times so that you won’t have extra spaces in the document.