Hi Paul,

I've just arrived back in the office and gave this a test. I believe it's working perfectly. There were a few errors with some files being open and some field issues but the macro itself seems to have updated every file required. I'm going to do a little bit more testing and will come back again but it looks the goods!

I got through some of the issues I was having (locked files, etc, which I found answers for from yourself on Google from 2012, thanks).

My next question is going to be if it's possible to add in a print option to the macro when it runs for each file? I tried the print function from Windows Explorer but it's chopping all sorts of margins off and is quite sloppy compared to the build in print function from Word).

We will remove the files we don't need before running the macro and that way everything will print out correctly as required.

Could you please let me know if this is possible?

Thank you.