Since you haven't posted the code that does the save, it's impossible to know what the issue with that aspect might be. For fully functional code, see
Run a Mailmerge from Excel, Sending the Output to Individual Files in the
Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html. Although that code produces the output as individual files, the core logic is the same.