<div>
the default paragraph formatting for merge fields adds trailing space as well as line spacing, if you select all the fields and remove the trailing space in Paragraph formatting you might find you can achieve the result you want
</div>


<div>
Thanks for the feeback. After looking, I only had around 26 that had a second line address so I just added the second line for those, printed them and then removed it. Then I printed the rest with just the one address line.
</div>


<div>
That's good operational practice ! us IT people frequently look for the 'perfect' answer with high automation and failing to recognise a bit of manual kicking around may be the best way - glad you got a resolution
</div>


<div>
<div class="content wysiwyg-content">
I'm using Word 2013 to create a mail merge from an Excel spreadsheet. When I'm doing the address, I'm using the columns for Name, Address Line 1, Address Line 2 and City,State,Zip. A majority of the customers don't have an second address line so I'm wondering how I can create this? If there is nothing in the Address Line 2 cell, then I just have a blank space in the mail merge. Is there a way to have an If/Then statement or something that says to not display it unless there is something in that field?<br />
<br />
Thanks!
</div>
</div>


I'm using Word 2013 to create a mail merge from an Excel spreadsheet. When I'm doing the address, I'm using the columns for Name, Address Line 1, Address Line 2 and City,State,Zip. A majority of the customers don't have an second address line so I'm wondering how I can create this? If there is nothing in the Address Line 2 cell, then I just have a blank space in the mail merge. Is there a way to have an If/Then statement or something that says to not display it unless there is something in that field?

Thanks!

If Then Field in Mail Merge

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.

Microsoft Word

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.