Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2023, 10:16 AM
cindy.wilkinson cindy.wilkinson is offline suppressing blank line using mail merge if then logic Windows 10 suppressing blank line using mail merge if then logic Office 2019
Novice
suppressing blank line using mail merge if then logic
 
Join Date: Jul 2023
Posts: 1
cindy.wilkinson is on a distinguished road
Default suppressing blank line using mail merge if then logic

I am using a mail merge to create 800+ annual salary letters. Some employees are receiving amounts for line items while others are not. I do not want the information to show on someone's letter if they are not receiving it. I have been able to do that using the If...then..else feature but it leaves a blank line. Is there a way to suppress a blank line when using an If..then..else rule? I am trying to suppress the blank lines after the COLA
Attached Images
File Type: png Screenshot 2023-07-07 111147.png (12.8 KB, 5 views)
Reply With Quote
  #2  
Old 07-07-2023, 10:32 PM
gmayor's Avatar
gmayor gmayor is offline suppressing blank line using mail merge if then logic Windows 10 suppressing blank line using mail merge if then logic Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Include the line break in the if ... then construction.
Press the Enter key where you see ¶



{ MERGEFIELD A }{ IF { MERGEFIELD B } <> "" "¶
Base Salary Retirement Contribution* { MERGEFIELD B }"}¶
{ MERGEFIELD C }
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Tags
blank line



Similar Threads
Thread Thread Starter Forum Replies Last Post
suppressing blank line using mail merge if then logic Suppress blank line in mail merge BernieB Mail Merge 8 03-07-2022 02:17 PM
suppressing blank line using mail merge if then logic Making mail merge blank fill a line to highlight that line rgm60527 Mail Merge 2 02-22-2022 11:13 AM
suppressing blank line using mail merge if then logic Suppressing Blank Conditional Sections in Mail Merge Ozzyy Mail Merge 3 05-08-2021 04:31 PM
suppressing blank line using mail merge if then logic I am getting blank lines with Mail Merge rtcary Mail Merge 1 01-20-2018 02:07 PM
suppressing blank line using mail merge if then logic Need help suppressing information in a table in a mail merge Laura123 Mail Merge 1 12-04-2017 01:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:50 PM.


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