Hi Paul



Its the second one. I tried to create the intermediate Directory.

Thanks.

Sorry for newbie question but how will I find the new thread?

There are no 'gotchas' - it's just a matter of carefully following the instructions. If you post a copy of the intermediate document with a few samples of the 'separate boxes', I might be able to tell you what the issue is.
You just posted in it!!!

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi

Thanks for the very kind offer.

I ran into a variety of related issues and in the end had a bash at formatting the data in Excel. I was able to do this after a flash of inspiration and so have solved the issue without needing to ask for further help.

The crunch was realising that processing in Excel was always going to be needed due to the many 1000s of rows of data and the need for conditional extraction of data for multiple mail merges and iterations over the data.

With the very best regards

Lorenzo