Leading Spaces and Tabs Removed with Inserted Database

Last reviewed: February 5, 1998
Article ID: Q122558
The information in this article applies to:
  • Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c

SUMMARY

Word removes leading spaces and leading tabs from your data records when you insert or merge an external database. By contrast, Word does not remove leading spaces when the data source is created in Word.

CAUSE

By design, Word removes leading spaces and leading tabsfrom external databases.

WORKAROUNDS

Use one of the following methods to add the missing spaces to your merge document:

Method 1: Insert extra spaces in the main document. These extra spaces

          should immediately precede the appropriate mergefield.

Method 2: Create a conditional mergefield to include spaces. The following
          mergefield example will insert five spaces if {mergefield name}
          equals John.

             {If {mergefield name} = "John" "     "}

          The following mergefield will insert five spaces and the result
          of the {mergefield name} in your document:

             {If {mergefield name} = "John" "     {mergefield name}"}


KBCategory: kbusage
KBSubcategory: kbmerge
Additional reference words: 6.0 6.0a 6.0c winword merge database
word6 datasource data source data records leading spaces blank
Keywords : kbmerge
Version : 6.0 6.0a 6.0c
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 5, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.