Hi all,



I have an issue where I'm pulling my clients' data from an external system to excel and it populates the entire address into one single cell.

Obviously when I'm mail merging the client data to Word, I need to break this down into separate fields 'address 1, 2 & 3' and 'post code'. The only way I can find to make this work is by manually separating the addresses in Excel from the single cell into 4, which is a very slow and manual process.

Does anyone know of a way I can ask Word to fragment the address as part of the MM - perhaps an instruction to use the next field after every comma - or have any other solution to the issue I've described?

Any help would be massively appreciated!

Have you tried using Excel's text-to-columns tool, using the commas as the field separators?

Mailmerges cannot parse address data that have been combined in a single field in the data source.

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

Ah no I had not. I've not used this tool before so will do some learning and try that. It sounds as though it could be exactly the solution I seek! Thank you