#1
|
|||
|
|||
Labels, Skip to next Field if Empty (without paragraph break)
I have been trying to create some labels and some of my fields are empty.
The fields that may be empty a Address_2 ; Address_3 ; Address_4 and County This is what my default MailMerge looks like at the moment: «Title» «Last_Name» «Company» «Address_1» «Address_2» «Address_3» «Address_4» «Town» «Postal_Code» «County» «Country» PROBLEM: If any of the fields are empty, there will be a paragraph break underneath them. Is there any way, maybe with IF conditions or any easier way, to tell Word to Skip to the Next Field if that one is empty? I've been looking on the internet for some time and I have not been able to find a solution, any help would be much appreciated! |
#2
|
||||
|
||||
Unless there is some other content on the same lines as your mergefields, they should be suppressed by default. That said, take a look at Mailmerge Empty Line Suppression in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Making paragraph text skip over a landscape page | iffee82 | Word | 2 | 03-31-2018 03:44 AM |
Interchange line break and paragraph break shortcut keys | skan | Word | 2 | 01-20-2017 03:50 AM |
Replacing paragraph formatting before column break also changes the next paragraph after the break | jjmartin1340 | Word | 3 | 09-21-2015 10:50 PM |
Macro to Skip Calcuation if Field is Blank?! | Elan05 | Word VBA | 9 | 05-09-2013 05:32 PM |
Create Page break in middle of Labels | Shragel | Word | 0 | 01-01-2013 08:03 AM |