Yes, it can be done via a macro, but that hardly makes it less complicated than a mailmerge - especially for an end-user who is unable to maintain the code when anything in the workbook or document changes.

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