Export a table or query to a Microsoft Word mail merge data source file

1. In the Database window, click the name of the table or query (Microsoft Access database only) you want to export, and then on the File menu, click Export.
   
   
2. In the Save As Type box, click Microsoft Word Merge (*.txt).
   
   
3. Click the arrow to the right of the Save In box, and select the drive or folder to export to.
   
   
4. In the File Name box, enter the file name, and then click Save All.

   Microsoft Access creates the data source containing the field names and all the data from your table.

Note   In a Word mail merge data source, the first record in the file contains the field names and is called the header row. All succeeding records are the data rows. The field names in the header record must match the field names in the main document. If they don't match, edit the field names either in the data source (you can open the data source in Microsoft Word) or in the main document so they do match.