Forum Discussion
Solved
Mail Merge and IF ""
Hello, I am a novice user and dont have much experience with mail merge. I have poked around on the internet for how to use the IF in mail merge. What I want to do: Hide a field and the relat...
Tony2021 The field construction that you are using is NOT the same as the one in my response
It will create new lines for the SWIFT and\or ABA if those fields contain data.
Tony2021 I assume that you have used CTRL+F9 to insert the field delimiters and that you have used ALT+F9 to toggle off their display. When the field codes are not displayed, you will not see anything unless you use the Preview Results facility.
To have it so that the paragraph does not appear, set up your document as shown below:
[Text of preceding paragraph.{ IF «SWIFT» <>""¶
SWIFT: «SWIFT»" }¶
[Text for following paragraph.]
Press the Enter key where the pilcrows (¶) appear in the above field construction.
Hi Doug and thank you for the response.
I want to make sure I am doing this correct.
I press enter key as instructed but I dont see that paragraph character anywhere and when I preview the blank space is still there.
here is a screen shot:
The yellow shade is where the field that will be hidden when ""
Here is the output. You can see the space where the SWIFT is ""
Tony2021 Turn on the display of non-printing characters by clicking on the Pilcrow button in the Paragraph section of the Home tab of the ribbon.
The following shows the field construction that you require:
HI Doug, thank you for the response. I have a follow up.
Wouldnt the above put the Account No and SWIFT on the same line if they are both NOT "" ?
I followed as described and it seems to be the case. I think we are on the right path but I am probably not following but maybe a little more info will help.
I am needing a separate line for each field and if "" then push the one below up into that space. I hope it makes sense.thank you very much.
below yellow shaded is what I edited it to based on response above:
Notice that I have a SWIFT line below it that performs as intended but only if its "" then I need it to be removed completely and the ABA below it to be pushed up into its place and therefore no spaces between Account No and ABA if swift was "". I hope it is not confusing.
here is the output for that yellow shaded line above (No and SWIFT are on the same line)
thank you Doug. Looking forward to your response.
Tony2021 The field construction that you are using is NOT the same as the one in my response
It will create new lines for the SWIFT and\or ABA if those fields contain data.
