How to changing data source in mail merge ms word

To change the data source in a mail merge in Microsoft Word, you can follow these steps:

Method 1: Using the Mail Merge Wizard

  1. Open your Word document and go to the "Mailings" tab in the ribbon.
  2. Click on "Select Recipients" and then "Use an Existing List" or "Type New List".
  3. If you're using an existing list, select the file and click "Open". If you're typing a new list, enter the data and click "OK".
  4. Click on "Finish & Merge" to open the Mail Merge Wizard.
  5. In the wizard, click on "Change Data Source" and select "Browse" to choose a new data source file.
  6. Select the new file and click "Open".
  7. Click "OK" to update the data source.

Method 2: Using the "Data Sources" Dialog Box

  1. Open your Word document and go to the "Mailings" tab in the ribbon.
  2. Click on "Select Recipients" and then "Data Sources".
  3. In the "Data Sources" dialog box, select the current data source file and click "Edit".
  4. In the "Edit Data Source" dialog box, click on "Browse" to choose a new data source file.
  5. Select the new file and click "Open".
  6. Click "OK" to update the data source.

Method 3: Using VBA Macro

  1. Open your Word document and go to the "Visual Basic" editor (press Alt + F11 or navigate to "Developer" tab and click on "Visual Basic").

  2. In the VBA editor, navigate to "Tools" > "References" and check if "Microsoft Word Object Library" is selected.

  3. In the "Immediate" window, type the following code and press Enter:

    ActiveDocument.MailMerge.OpenDataSource "C:\Path\To\New\Data\Source.xlsx"

    Replace "C:\Path\To\New\Data\Source.xlsx" with the actual path and file name of your new data source file.

  4. Close the VBA editor and return to your Word document.

Note: Make sure to update the data source file path and name accordingly in all methods.