#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I need to remove rows in a table where the Merge field is empty | WordMonkey1 | Mail Merge | 2 | 10-28-2020 12:25 AM |
Mail merge: remove empty rows when a field is not showed | Yarikh | Mail Merge | 4 | 09-23-2018 12:17 AM |
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 |