What to Do if Blank Fields Leave Blank Space in a Mail Merge Document (WP, DB)

When printing a ClarisWorks Mail Merge document, the program should automatically remove empty fields occurring in multiple address lines. If, for example, you place the fields on your mail merge document in this order:
Name
Address 1
Address 2
CityStateZip

And a record does not contain anything in Address 2, that record should print CityStateZip directly below Address 1 automatically.

If you don't find this to be true, the following is a method of dealing with the problem. It should be noted that this method should not be necessary under most circumstances:

Create the following field:
Full Address (Calculation, text result) =
IF(ISBLANK('Address2'), 'Address1', CONCAT('Address1', CHAR(13), 'Address2'))

This formula checks for a blank Address2 field and just outputs Address1 if Address2 is blank. If Address2 contains data, the calculation outputs Address1, a carriage return (CHAR(13) and the Address2 field. The Carriage Return will not function or display in the ClarisWorks DB layout, but it is there. It will function properly when doing the Mail Merge in the Word processor.

The field Full Address is used in the Mail Merge instead of Address1 and Address2.