In order to create a word mail merge with information from the database it must first be exported to Excel (despite the option in the Data Merge Manager to get source data from a Filemaker Pro Database.)

1. In Filemaker Pro, choose "Export Records..." from the File menu.
   
   
   
   
2. Name the file and select "Excel" from the "Type" pull down menu. Choose your destination file location and click "Save."
   
   
   
   
3. Fill in the dialogue options to name the worksheet etc. Click "Continue."
   
   
   
   
4. A Dialogue to select the export fields appears. The default selection of fields only included the fields that are on the current layout. To include all fields in the Families Table be sure to select that option. (see below)
   
   
   
   Select the fields that you wish to export. And click "Export."
   
   
   
   
5. In the Finder navigate to the file you created and double click, it will open automatically in Excel.