How to save mail merge as separate word documents

When using mail merge in Microsoft Word, you can save the merged documents as separate Word documents. Here's how:

Method 1: Using the "Save As" dialog box

After completing the mail merge, go to the "Mailings" tab in the ribbon.
Click on the "Finish & Merge" button in the "Finish" group.
Select "Edit Individual Documents" from the dropdown menu.
In the "Save As" dialog box, select a location to save the files.
In the "File name" field, enter a prefix (e.g., "Merged_") and a suffix (e.g., ".docx") to create a unique file name for each merged document.
Click "Save" to save each merged document as a separate Word file.

Method 2: Using a macro

You can also use a macro to save the merged documents as separate Word files. Here's an example macro:

Open the Visual Basic Editor by pressing Alt + F11 or by navigating to "Developer" > "Visual Basic" in the ribbon.
In the Visual Basic Editor, insert a new module by clicking "Insert" > "Module" or by pressing Alt + F11.

Paste the following code into the module:

Sub SaveMergedDocumentsAsSeparateFiles()
 Dim doc As Document
 Dim i As Integer
 Dim filename As String

 ' Set the output directory
 outputDir = "C:\Merged Documents\"

 ' Loop through each merged document
 For Each doc In ActiveDocument.MailMerge.MainDocumentType
     ' Set the file name
     filename = outputDir & "Merged_" & i & ".docx"

     ' Save the document
     doc.SaveAs filename

     ' Increment the file name counter
     i = i + 1
 Next doc
End Sub

Save the module by clicking "File" > "Save" or by pressing Ctrl + S.
Close the Visual Basic Editor.
Go back to your mail merge document and click "Finish & Merge" > "Edit Individual Documents".
The macro will run and save each merged document as a separate Word file in the specified output directory.

Note: Make sure to adjust the outputDir variable to the desired location where you want to save the merged documents.

Mail Knowledge

How to save mail merge as separate word documents