Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-07-2022, 12:16 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 how to delete whole line if the merge field is empty

Hello,

Please see below. I have two lines with two merge fields in the middle which are linked on my excel to two column.
The goal is, if one of the columns are empty in excel, merge needs to delete that line completely with all sentence without a line break on the text.


I tried to use /b trick on the mergefield code but it didnt worked. Anyone with any idea how to do ? I attached my both excel and word files.

Heading
You are «Age1» years old.
You are «Age2»years old.
Text text text
Text text


Goal :

Heading
You are 12 years old.
Text text text
Text text



Thanks a lot
Attached Files
File Type: docx merge word.docx (14.1 KB, 7 views)
File Type: xlsx merge excel.xlsx (8.4 KB, 4 views)
Reply With Quote
 



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 04:15 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