How to change data source in word mail merge 2010

To change the data source in Word Mail Merge 2010, follow these steps:

  1. Open your Word document that contains the Mail Merge fields.
  2. Go to the "Mailings" tab in the ribbon.
  3. Click on the "Select Recipients" button in the "Start Mail Merge" group.
  4. In the "Select Recipients" dialog box, click on the "Use an Existing List" option.
  5. Browse to the new data source file (e.g. Excel spreadsheet, Access database, etc.).
  6. Select the file and click "Open".
  7. In the "Select Table" dialog box, select the table or query that contains the data you want to use for the Mail Merge.
  8. Click "OK" to close the dialog box.
  9. Word will then update the Mail Merge fields to reflect the new data source.

Alternatively, you can also change the data source by using the "Mailings" tab and clicking on the "Update Recipients" button in the "Actions" group. This will allow you to select a new data source file and update the Mail Merge fields accordingly.

Note: If you are using a dynamic data source (e.g. a query or a table that is updated regularly), you may need to update the data source regularly to reflect any changes to the data.

Also, you can use the "Mail Merge Wizard" to change the data source, follow these steps:

  1. Go to the "Mailings" tab in the ribbon.
  2. Click on the "Finish & Merge" button in the "Finish" group.
  3. In the "Merge to Document" dialog box, select the "Edit Individual Documents" option.
  4. Click on the "Change Data Source" button.
  5. Browse to the new data source file and select it.
  6. Click "OK" to close the dialog box.
  7. Word will then update the Mail Merge fields to reflect the new data source.

It's worth noting that if you are using a large data source, it may take some time to update the Mail Merge fields, so be patient and let the process complete.