You receive a prompt to select a text encoding format when you run a VBA program that was developed in Microsoft Word 2002 (870699)
The information in this article applies to:
SYMPTOMSWhen you try to open a text file to perform a mail merge in your Microsoft Visual Basic for Applications (VBA) program that you developed in Microsoft Word 2002, you may receive a prompt to select a text encoding format.CAUSEThis behavior occurs because the plain text file format cannot contain text encoding.RESOLUTIONTo resolve this behavior, you must use a Microsoft Word file as a document file ( a .doc file) to store your data for the mail merge program. To save an existing text file in Word format, open the text file in Word 2002, and then use the Save As command to save it as a document file. To do this, follow these steps: - Start Word 2002.
- On the File menu, click Open.
- In the Look in list, click the appropriate drive and folder where your text file resides.
- Click the Files of type list, and then click All Files.
- In the Open dialog box, click Your_File_Name.txt (where Your_File_Name.txt is the name of your text file), and then click Open.
- On the File menu, click Save As.
- Click the Save as type list, and then click Word document.
- Click Save.
- Change the name of the file in your VBA program from Your_File_Name.txt to Your_File_Name.doc.
- Run your VBA program for a mail merge.
Modification Type: | Major | Last Reviewed: | 8/23/2004 |
---|
Keywords: | kbtshoot kbprb KB870699 kbAudEndUser kbAudITPRO |
---|
|