Microsoft KB Archive/282465

= Works: Extra Spaces Added in Place of Null (Empty) Fields =

Article ID: 282465

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Works Suite 2000
 * Microsoft Works Suite 2001
 * Microsoft Works 2000 Standard Edition
 * Microsoft Works 6.0
 * Microsoft Works 7.0
 * Microsoft Works Suite 2002
 * Microsoft Works Suite 2003

-



This article was previously published under Q282465



SYMPTOMS
If you have multiple fields separated by a space and placed on the same line next to each other, then when you perform a mail merge using a Microsoft Works database file, an extra space appears in the results. For example, if you have the following fields

Dear <> < > <> <>

and you merge a the husband's name but not the wife's name, the result will look like this:

Dear Nicholas   Smith

An extra space is shown between first name and last name.



CAUSE
This issue occurs if a field that is null (empty) is placed next to a space in the document. In the example in the &quot;Symptoms&quot; section, the fields &quot;and1&quot; and &quot;Wife&quot; are empty.



RESOLUTION
To work around this issue, do not insert spaces between the fields so that the null (empty) fields create the space. For example, set up your fields in the form letter like this:

Dear <>< ><> <>,

Note that there are no spaces between the &quot;Husband&quot;, &quot;and1&quot;, and &quot;Wife&quot; fields. If you have a couple, you not only put in the second name, but fill the &quot;and1&quot; field with &quot;and&quot; so that the fields are concatenated to form a single salutation.

Note If you do not use an &quot;and1&quot; field, you can create one in the database by clicking Insert Field on the Format menu.

Additional query words: space extra unexpected print merge blank spaces double

Keywords: kbprb KB282465

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.