Avatar of itgolfer

asked on 

If Then Field in Mail Merge

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?

Microsoft WordMicrosoft ExcelVBA

Avatar of undefined
Last Comment

8/22/2022 - Mon