Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2022, 02:52 PM
macropod's Avatar
macropod macropod is offline how to delete whole line if the merge field is empty Windows 10 how to delete whole line if the merge field is empty Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


See Mailmerge Empty Line Suppression in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
You can use the \b and \f switches together.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 04-07-2022, 03:56 PM
orhancelil orhancelil is offline how to delete whole line if the merge field is empty Windows 10 how to delete whole line if the merge field is empty Office 2016
Novice
how to delete whole line if the merge field is empty
 
Join Date: Apr 2022
Posts: 2
orhancelil is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
See Mailmerge Empty Line Suppression in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
You can use the \b and \f switches together.
Oh thats a great content, thank you so much but i think i am soo dumb to solve. I am trying for 30mins every possible combinations but i didnt understand where to put f or b and which page break icon to get into the field, previous one or next one. So i tried all combinations like only f only b, b and f together etc etc but still line is not disappearing at all :/

Is it because i have text-merge field-text, is that mixing the mentioned logic on the guide?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to delete whole line if the merge field is empty I need to remove rows in a table where the Merge field is empty WordMonkey1 Mail Merge 2 10-28-2020 12:25 AM
how to delete whole line if the merge field is empty Mail merge: remove empty rows when a field is not showed Yarikh Mail Merge 4 09-23-2018 12:17 AM
how to delete whole line if the merge field is empty Delete Line of Bookmark if the Text is Empty ljg713 Word VBA 1 12-21-2015 04:27 PM
Delete paragraph base on merge field BenEWill Mail Merge 1 07-02-2014 02:52 PM
Mail Merge Empty Data Field Licos101 Mail Merge 2 04-10-2014 06:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:56 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