The information in this article applies to:
SYMPTOMSWhen you import a Microsoft Excel worksheet as your address list, one of the following may occur: Case 1: Postal Codes MissingPostal codes may be missing on all or part of your mailing list addresses.Case 2: Incomplete Postal CodePostal codes that begin with a zero (0) do not include the zero. For example, if your postal code should be 01234, when you import your address list, the postal code may be imported as 1234.CAUSEThis problem can be caused by any of the following:
WORKAROUNDTo work around this problem, use one of the following methods appropriate for your situation: In Microsoft ExcelTo ensure that Direct Mail Manager interprets your postal code fields as text, type an apostrophe (') before the postal code. For example, in Excel when you type the postal code for an address (for example, 98052-6399), type '98052-6399.NOTE: Be sure to type the apostrophe when you type each address in your Excel address list. In Excel, the apostrophe (single quotation mark) is a formatting code. For more information about formatting codes, click Microsoft Excel Help on the Help menu, type apostrophe in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned. In a Text EditorTo ensure that Direct Mail Manager interprets your postal code fields correctly when you import a text file (*.txt), make sure to enclose your address fields within quotation marks. For example, in a typical comma-separated (CSV) text file, make sure your address fields are enclosed within quotation marks:"Name","Address","City","State","PostalCode" STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. Additional query words: zip zipcode postalcode 5-digit 9-digit
Keywords : kbdta kbmerge kbdmm wd2000 |
Last Reviewed: September 30, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |