Thanks Macropod - got there in the end.

After more than a week of running the macro, I now try to launch the macro, using the exact same steps as before, and am instantly met with the 'microsoft office word has stopped working' error message.

I haven't changed anything, and I even uninstalled and repaired microsoft office. I also thought it may have been too large a document, so I ran it on some test data, with one row, and still got the same error.

Any help/ideas is appreciated.

Thanks
rmk911