Hi iansan,

You could use a macro to re-arrange the data for a mailmerge. Alternatively, you could use an Excel macro to open a Word document and populate it with the data. Whichever way you go, though, you need a reliable method of identifying which records relate to a given client. I doubt that can be done where the client details are missing - unless there's another field in the data to identify the client by an ID code. Then there's the issue of whether the data are sorted by client. A mailmerge can handle this last issue, but you'd have to program it yourself if you were to automate Word from Excel.

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