Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 09-13-2020, 02:29 PM
Khalil Khalil is offline Suppress blank lines Windows 10 Suppress blank lines Office 2010
Novice
Suppress blank lines
 
Join Date: Sep 2020
Location: Melbourne
Posts: 3
Khalil is on a distinguished road
Default

I have a directory where I wish to keep two records in one page.
To keep the second record in the same page I used "If... then:"
Code:
{IF { MERGEFIELD } ADDRESSE2} = <> "" { MERGEFIELD} ADDRESEE2 } ""}
When the field is blank, I shall have a blank line that I want to get rid of, and when I remove the line, in the following records, if the field is not blank I shall have the following on the same line:
<<Addresee2>> <<Suburb>>
I want to keep the <<Suburb>> in a separate line, which is impossible for me to fix.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Suppress blank lines Suppress blank lines in mailmerge of excel reports into word document beefcake2000 Mail Merge 1 11-10-2017 12:54 PM
Suppress blank lines Suppress comma in "city , stat zip" line when blank DHammer Mail Merge 1 05-30-2014 02:43 AM
Suppress Header/Footer on Blank Pages in Book SQLUSA Word 5 08-19-2012 03:51 PM
Suppress blank lines Getting blank lines instead of supressed lines. Welshie82 Mail Merge 2 11-14-2011 01:41 AM
Suppress blank lines How to turn all blank lines into non-blank for legal forms sieler Word 3 04-12-2009 01:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft