Microsoft KB Archive/38485

From BetaArchive Wiki

Mac Works: Suppressing Blank Lines in a Multiple Field Merge

PSS ID Number: Q38485 Article last modified on 10-22-1998

2.0 3.0

MACINTOSH

====================================================================== 2.00 3.00 MACINTOSH kbprint

The information in this article applies to:
- Microsoft Works for the Macintosh, versions 2.0 and 3.0

SYMPTOMS

If the Multiple Label option is selected and you perform a print merge in Works version 2.0 or 3.0, fields containing no data will not compress.

By performing a record selection, it is possible to do a two-pass merge that will eliminate the blank spaces within a merge.

For example, a database with Title, Name, Company, and Address fields may not have a company entered for each record.

Microsoft has confirmed this to be a problem in Works versions 2.0 and 3.0 for the Macintosh. This problem was corrected in Works 4.0, which compresses blank fields during a print merge.

WORKAROUND

To work around this problem in Works 2.0 or 3.0, do the following:

  1. Perform a record selection using the rule “Company is blank”.
  2. Merge the first set of labels with the appropriate fields, but without the Company field in the merge document.
  3. Perform another record selection with the rule “Company is not blank”.
  4. Add the Company field to the merge document.
  5. Print merge the second set of labels.

KBCategory: kbprint KBSubcategory: macworkskb

Additional reference words: 2.00 multiple column 3.00 label mwkswp mwksdb macworks ====================================================================== Keywords : kbprint Version : 2.0 3.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.