Forum Discussion
Mail Merge and IF ""
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.
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.
- I have good news. It worked! I didnt notice the extra brackets in your original post and it took awhile to learn how to put the backs of the brackets next to eachother. It was pretty tedious work indeed with control F9. My brain is tired now. Thank you for the expert assistance and hanging in with me. I learned something new. Have a good night.