Remove blank lines in mail merge using table

wacobc · #1 08-19-2021, 09:35 AM

I am attempting to create an address/phone directory mail merge in Word, data source is Excel.
Like many others that have posted, I find that blank lines reside where there is no data in the source file - such as having 2 address lines but only 1 populated. I tried the \b "" trick - both with and without using a table. I cannot get it to work to remove the blank lines either way. I have attached files for both styles with the mail merge codes (\b trick is removed).
Is there a way to remove the blank lines other than manually after finishing the merge?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge Template - remove blank rows in a table	Litmus	Mail Merge	16	03-23-2022 01:42 PM
Table Merge _ Auto Delete Blank Lines (without Data)	Alex1s85	Mail Merge	7	05-04-2020 05:12 AM
Blank Lines in Mail Merge - Other Options not working	cluyster1127	Mail Merge	13	12-11-2019 01:05 PM
I am getting blank lines with Mail Merge	rtcary	Mail Merge	1	01-20-2018 02:07 PM
Eliminating blank lines in mail merge (labels)	BeerStud	Mail Merge	1	11-28-2014 06:29 PM