#1
|
|||
|
|||
if/then/else and blanks
this is what i have. how do i avoid blank lines here? I have 40 if the else lines.
Code: {if {mergefield colum1} = "1" "UGRD Bank Statement" ""} {if {mergefield colum2} = "1" "I20 Form" ""} {if {mergefield colum3} = "1" "GR Bank Statement for I20" ""} {if {mergefield colum4} = "1" "Graduate English Language Test" ""} Result: UGRD Bank Statement GR Bank Statement for I20 Graduate English Language Test Desired Result: UGRD Bank Statement GR Bank Statement for I20 Graduate English Language Test |
#2
|
||||
|
||||
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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
follow up
thank you. a few follow up questions:
1. can you explain #3 a bit more - how to move a paragraph break into field code? 2. where do i put the \b in a if/then/else notation? {if {mergefield colum4} = "1" "Graduate English Language Test" ""} JM |
#4
|
||||
|
||||
Quote:
You don't - the \b and \f switches are alternative means of displaying conditional content with the mergefield.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
ok - so i'm back to where i started. how do i suppress the blank lines with the if/then/else notation:
{if {mergefield colum4} = "1" "Graduate English Language Test" ""} |
#6
|
||||
|
||||
You do it via the method described in the link I gave you...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
merge fields |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to refer to a variable with BLANKs | Officer_Bierschnitt | Excel Programming | 13 | 11-05-2015 07:40 AM |
CountA function to Count Blanks | Alaska1 | Excel | 10 | 02-11-2015 04:20 PM |
Counting Blanks in 1 Column and Non-Blanks in Another | dogwood705 | Excel | 4 | 02-07-2015 08:45 AM |
how to replace a full paragraph with blanks? | dylansmith | Word | 8 | 10-22-2012 11:51 PM |
fill blanks in box | keevitaja | Word | 1 | 05-23-2011 06:34 PM |