View Single Post
 
Old 06-30-2022, 11:30 AM
caroleemoreno caroleemoreno is offline Windows 10 Office 2019
Novice
 
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