See '
Send Mailmerge Output to Individual Files' and '
Split Merged Output to Separate Documents' in:
https://www.msofficeforums.com/mail-...ps-tricks.html. The code for '
Send Mailmerge Output to Individual Files' saves the file to the same folder as the mailmerge main document and the code for '
Split Merged Output to Separate Documents' saves the file to the same folder as the source document, respectively, but you could specify a different folder.