Problem exporting multi-line contact street addresses in Outlook

Monday, November 17, 2008

When you export Microsoft Outlook Contacts in either a comma or tab separated values 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. In a comma or tab delimited file, carriage returns are interpreted as record delimiters. For troubleshoot this problems get Outlook support and follow the below given steps:

You can trouubleshoot using two method

Use CSV Format
Export 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.

Manipulate the file in Microsoft Word
Export the file in either a comma separated values or tab separated values format, and then open the output file in Word. Then, manipulate the data as follows:
1. On the Edit menu, click Replace. If the Special button does not appear, click More to expand the dialog box.
2. In the Find What box, type a double quotation mark ("). Then click Special and click Paragraph Mark.
3. In the Replace With box, type any special character not found in your data, such as a pound sign (#).
4. Click Replace All.
5. In the Find What box, click Special and click Paragraph Mark.
6. In the Replace With box, type whatever character you would like to use to separate the multiple street address lines, such as a percent sign (%).
7. Click Replace All.
8. In the Find What box, type the special character used in step 3.
9. In the Replace With box, click Special and click Paragraph Mark.
10. Click Replace All.
After completing this procedure, your file will have one record for each contact. The multi-line street address will be in one field, surrounded by quotation marks. Each street address line will be separated with the character chosen in step 6.