View Single Post
 
Old 01-08-2018, 03:22 PM
ghampton ghampton is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Jan 2018
Posts: 4
ghampton is on a distinguished road
Default Word 2013 mail merge directory conditional printing city if value changes

Hello All. To put it simply, I need to create a directory of our offices. I have already created a successful mail merge of the data and it looks pretty good. Now I need to fine tune it. What I want to do is to print the city to the far left if it is a different city and nothing if it is the same city.

My merge works just fine and indenting / formatting shouldn't be a problem for me, I just need to know how to print the city if different from the last one, else skip it. Here is a short example of what I am looking for. The Bold Underline field is { MERGEFIELD Address_City } and is the key field for this. The display below is sort of what the output should be, although I shortened it up for the post.

DIRECTORY

Atascosa
Company Address Atascosa, TX zip
Company 2 Address Atascosa, TX zip

San Antonio
Company 3 Address San Antonio, TX zip
Company 4 Address San Antonio, TX zip
Company 5 Address San Antonio, TX zip
Company 6 Address San Antonio, TX zip

Von Ormy
Company 7 Address Von Ormy, TX zip

Thank you in advance for your help
Reply With Quote