How to save mail merged documents separately

When you use mail merge in Microsoft Word, the resulting documents are typically saved as a single file. However, there are a few ways to save the mail merged documents separately:

Method 1: Using the "Save As" dialog box

  1. After running the mail merge, click on the "File" menu and select "Save As".
  2. In the "Save As" dialog box, select a location to save the file.
  3. In the "File name" field, enter a name for the file (e.g., "Document 1").
  4. Click on the "Tools" button next to the "Save" button.
  5. In the "Tools" dialog box, select "Options" and then check the box next to "Save each document as a separate file".
  6. Click "OK" to save the file.

Method 2: Using a macro

  1. Open the Visual Basic Editor in Microsoft Word by pressing "Alt + F11" or by navigating to "Developer" > "Visual Basic" in the ribbon.
  2. In the Visual Basic Editor, insert a new module by clicking "Insert" > "Module".
  3. Paste the following code into the module:
    Sub SaveMailMergeDocumentsSeparately()
     Dim doc As Document
     For Each doc In ActiveDocument.MailMerge.MainDocumentType
         doc.SaveAs "C:\Path\To\Saved\Files\" & doc.Name & ".docx"
     Next doc
    End Sub
  4. Replace "C:\Path\To\Saved\Files\" with the desired location to save the files.
  5. Click "Run" > "Run Sub/User Form" to execute the macro.
  6. The macro will save each mail merged document as a separate file.

Method 3: Using a third-party add-in

There are several third-party add-ins available that can help you save mail merged documents separately. For example, you can use the "Mail Merge Manager" add-in, which allows you to save each document as a separate file with a single click.

I hope these methods help you save your mail merged documents separately!