The information in this article applies to:
SYMPTOMSWhen you export Microsoft Outlook Contacts in either comma or tab delimited format, any street addresses that contain more than one line are exported with carriage returns separating the multiple lines. This may result in a skewed output file containing multiple records for those contacts containing multi-line street addresses. CAUSEIn a comma or tab delimited file, carriage returns are interpreted as record delimiters. RESOLUTION
There are two options for correcting this problem:
Use CSV FormatExport the file in comma separated values (CSV) format; then open the file in Microsoft Excel. The file will import correctly with one record per contact and the multi-line street address in one cell. You may need to change the row height in order to see the second line of the address.NOTE: This option will not work if you export the file in tab-delimited (TSV) format. Manipulate the file in Microsoft WordExport the file in either comma-delimited or tab-delimited format, and then open the output file in Word and manipulate the data as follows:
MORE INFORMATION
The following illustrates the problem described in the "Symptoms" section
and the result of performing the procedure described in the "Resolution"
section.
The exported file will contain a carriage return ([CR]) following the word "Lane" which results in two separate records for this one contact, as follows:
After performing the procedure described in the "Resolution" section, the resulting output will look as follows:
Additional query words:
Keywords : IntpImEx |
Last Reviewed: May 14, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |