Microsoft KB Archive/228793

= WD2000: DMM: All Postal Codes Not Imported from Excel Worksheet =

Article ID: 228793

Article Last Modified on 12/8/2000

-

APPLIES TO


 * Microsoft Word 2000 Standard Edition
 * Microsoft Direct Mail Manager for Windows

-



This article was previously published under Q228793



SYMPTOMS
When you import your address list contained in a Microsoft Excel worksheet, all of the postal codes (ZIP codes) may not be imported.



CAUSE
Direct Mail Manager (DMM) requires that numbers, such as postal codes, be formatted as text. DMM ignores numbers that are formatted as either General (default cell format in Excel) or Number in an Excel worksheet.



RESOLUTION
Use one of the following methods to correct this problem:

Method 1: Format the Postal Code Column as Text
 In Excel, open the worksheet that contains your address list.

NOTE: If you receive the following error message when you attempt to open your address list, close Direct Mail Manager and try again.

Cannot access ' .xls'

 Select the column that contains the postal code. On the Format menu, click Cells. On the Number tab, under Category, select Text and then click OK. Save and close your Excel worksheet.

Method 2: Add an Apostrophe Before the Postal Code
Add an apostrophe as the first character of the postal code, as in the following example:

'98052-6399

When you add the apostrophe at the start of a cell, Excel automatically marks that cell as a Text/Label cell and not as a General or Number format cell.

Keywords: kbprb KB228793

-

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

© Microsoft Corporation. All rights reserved.