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?

Thanks!

ASKER CERTIFIED SOLUTION

Professor J

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

SOLUTION

GrahamSkan

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

regmigrant

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

itgolfer

ASKER

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.

regmigrant

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