Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-30-2022, 11:30 AM
caroleemoreno caroleemoreno is offline Suppress blank lines with IF THEN ELSE Windows 10 Suppress blank lines with IF THEN ELSE Office 2019
Novice
Suppress blank lines with IF THEN ELSE
 
Join Date: Jun 2022
Posts: 5
caroleemoreno is on a distinguished road
Default Suppress blank lines with IF THEN ELSE

Hello. I have the following if then statement with a mail merge and I can not figure out how to suppress the blank lines when the result is empty in the merge file. I have tried \b and entering ¶, but I still get blank spaces when the result is empty . I have also tried other solutions on this forum and nothing works. Can someone help? Here are two of the 20 lines. If the value is empty, I want it to suppress the blank lines .

{IF{MERGEFIELD Bulletin Board }= "" "Furniture First Bulletin Board" ""}


{IF {MERGEFIELD Man_Wah_Central_Bill}= "" "Man Wah Cheers Container Buys" ""}

Thanks in advance!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Suppress blank lines with IF THEN ELSE Suppress blank line in mail merge BernieB Mail Merge 8 03-07-2022 02:17 PM
Suppress blank lines with IF THEN ELSE Suppress blank lines Khalil Mail Merge 4 09-13-2020 10:41 PM
Suppress blank lines with IF THEN ELSE Suppress blank lines in mailmerge of excel reports into word document beefcake2000 Mail Merge 1 11-10-2017 12:54 PM
Suppress Header/Footer on Blank Pages in Book SQLUSA Word 5 08-19-2012 03:51 PM
Suppress blank lines with IF THEN ELSE 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 09:50 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