Article ID: 286901
Article Last Modified on 1/31/2007
APPLIES TO
- Microsoft Office Word 2003
- Microsoft Word 2002 Standard Edition
This article was previously published under Q286901
SYMPTOMS
When you use a comma-separated variable (CSV) file as the data source for a mail merge in Microsoft Word, you find that an inordinate amount of time is required for Word to attach and process the data.
WORKAROUND
To work around this behavior, import the CSV data file into a Microsoft Excel worksheet, and then use the worksheet file as the data source for your mail merge. To do this, follow these steps:
- Start Excel. On the File menu, click Open.
- In the Files of type list, select Text Files (*.prn; *.txt; *.csv).
- Browse to select the CSV file that contains the mail merge data, and then click Open.
- On the File menu, click Save As.
- In the Save As dialog box, change the Files of type box to Microsoft Excel Workbook (*.xls), and then click Save.
- Exit Excel.
You can now use the Excel workbook instead of the text file as the data source for the mail merge. If you have a large data source file, the extra time taken to convert it to an Excel worksheet is more than compensated by the time saved in attaching the data file in the Word mail merge.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Additional query words: WD2002 WD2003
Keywords: kbbug kbmerge kbnofix KB286901
