Morning Frosty, not to worry! I knew you'd stumble upon them eventually. Ever the hero

My code has not changed at all since the last lot that was posted. I was happy that it worked enough for it to be operable, but the operator is finding it a little problematic, and has raised a few issues.

You're absolutely correct about me wanting the results of the merge - I just need a word document with the text in it from my spreadsheet!!

When I said about ending the merge, I mean that firstly it doesn't toggle the preview, which was what AutoNew was doing (badly). Secondly, the documents still seem connected. What I mean by this is that if you were to reopen the word document, it would always ask if you want to refresh the source (not sure of the exact terminology), which isn't ideal. I think you're idea of using .Execute may work, as that sounds like the process would be closed by the end of it. However, if I change .OpenDataSource to .Execute, then "Named argument not found" and the debugger selects "Name:=strSourcePath". I thought it may be as a consequence of it not being defined, but it very much is defined.

One thing I've been trying to get it to do is to add a random number to the name string, to avoid an error whereby you may already have a quote open with an identical name. Additionally, the file names/destinations can be quite long, as some quotations are stored deep within a server here. As a consequence, almost always I get the error with regards to the character string being more than 255 characters. Is there some way round this as it's become quite problematic?