You might be interested in the
Send Mailmerge Output to Individual Files topic in the
Mailmerge Tips & Tricks 'Sticky' thread:
https://www.msofficeforums.com/mail-...ps-tricks.html. The code there allows you to nominate any suitable data field for the file name and, if you follow the instructions in the notes below that topic, the process is entirely transparent to the user. As for having the filename in the footer, all you need do is add a FILENAME field to the mailmerge main document's footer.