Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Office Address Book export contains extra Tab character in data records in Word for Mac
Article ID: 275417 - View products that this article applies to.
This article was previously published under Q275417
After you export the Office Address Book from Microsoft Entourage, and then the file is opened in Microsoft Word for Mac, the data records contain one more tab character than the header record.
Because the tab characters are used to separate data fields in the data records (as field delimiters), it may appear that the data records contain an extra field that is not accounted for in the header record. This can cause problems when you try to use this data in another program.
For example, if you try to use this data as a data source for a Word data merge, the following error message may appear:
Record 1 does not have the same number of fields as the first row in (file name). Ensure that all records have the same number of fields.
To work around this problem, export the Address Book to a file, and then modify the file using Microsoft Excel 2001 for Mac or Word for Mac before using the file in another program.
To do this, use either of the following methods.
Method 1: Export the Address Book and Use Excel 2001 for Mac to Modify Your File
Method 2: Export the Address Book and Use Word 2001 for Mac to Modify Your File
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.