Since you haven't posted whatever code you're working with, it's impossible for anyone to provide meaningful advice about that.
That said, see:
•
Split Merged Output to Separate Documents and, better still,
Send Mailmerge Output to Individual Files in the
Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum -
https://www.msofficeforums.com/mail-...s-tricks.html; and
•
https://www.msofficeforums.com/137121-post2.html &
https://www.msofficeforums.com/129119-post4.html. The For each Tbl loop in either post could simply be inserted before the 'Save As' line in either of the macros referred to above.