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
- After running the mail merge, click on the "File" menu and select "Save As".
- In the "Save As" dialog box, select a location to save the file.
- In the "File name" field, enter a name for the file (e.g., "Document 1").
- Click on the "Tools" button next to the "Save" button.
- In the "Tools" dialog box, select "Options" and then check the box next to "Save each document as a separate file".
- Click "OK" to save the file.
Method 2: Using a macro
- Open the Visual Basic Editor in Microsoft Word 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".
- 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
- Replace "C:\Path\To\Saved\Files\" with the desired location to save the files.
- Click "Run" > "Run Sub/User Form" to execute the macro.
- 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!