In Word I have started a Mail Merge and it looks like.
As background, not all blanks in MailMerge are treated as blank for the purpose of blank line suppression.
Select the Commands tab.
Here's the issue.End If, if so, and ext_b1 is always the same non-blank value when it is "not False" and borrower_1 is never more than about 120 characters long (that's ottomh, you should check you can use a wildcarding trick to simplify the IF test and make." mergefield borrower_1 " mu dominium trade hacker ".On the right, in the Commands frame, highlight the option "Mail Merge Helper".Mergefield fields that have a blank result are treated as blank." mergefield borrower_2 " "." mergefield borrower_1 " IF " mergefield ext_b2 mergefield borrower_2 " "True?Drag and drop Mail Merge Helper to the location on the desired Toolbar on the main page.Use the Mail Merge Helper from Word 2000: Open Word 2002XP, right-click on any Toolbar and select Customize.If ( ext_b1 is False or borrower_1 is blank ) don't insert anything, not even a blank line.
I am assuming that the logic you require is along the following lines.
«First_Names» «Last_Names «children «street «city «State» «Zip «telephone».
I don't want the blank line.IF " mergefield ext_b1 mergefield borrower_1 " "True?Afaics that is what you have now done.To deal with that, what you can do is insert the paragraph mark inside the If "is true result" and put all the IF fields on one line, like this: IF " mergefield ext_b1 mergefield borrower_1 " "True?IF " mergefield ext_b2 mergefield borrower_2 " "True?But the result of an IF field is never treated as blank.Fixing this kind of problem by manipulating the data source (e.g.Ordinary typed white space such as spaces and tabs are treated as blank.I have an Excel Spreadsheet with Names, Addresses, etc.I have seen this question asked before, but I am not understanding the answer and need further help.