Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-12-2020, 03:36 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 Suppress blank lines


Hi,
I have a mail merge directory where let's say a specific field is sometimes blank and sometimes not blank. I am also using the "If ... then" condition. After completing the merge, if the field is empty or blank the merge will display a blank line. I've been trying for days to find a solution to hide the blank line but failed. I've found a lot of solutions on the web such as using the switch \b and \f, which I found useless may be because I don't understand the way they work. However, I can hide the blank line using any suggested technique but my big problem is when the field is not empty the following field will appear on the same line with the previous one, and this is not what I want. I wish to hide the blank line when the field is not empty without affecting the appearance of the merge when the field is not empty. In other words, I want each field on a separate line. I understand the blank line is suppressed by default but not when using "IF". This is very disappointing and would appreciate a clear well explained solution.
Thank you
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 12:14 AM.


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