I've found some very useful macro code which helps me to automatically merge and save individual PDFs documents.
I've associated the macro with a button in a MSWord document. It automatically opens my MSWord document (which is a certificate) that contains merge fields linking it to a MSAccess query and then creates individucal MSWord documents for each records and finally PDFs them in the same process.
Everything works as I would except it to and all PDFs get created, however I'm receiving this error at the end of the process, "This file is in use by another application or user."
Can anyone help with with why this happens? I have attached a text document with the code.
Thanks in advance