There's probably an Excel vba solution for this, but there's also a Word mailmerge/vba solution using Word's Catalogue/Directory
Mailmerge facility (the terminolgy depends on the Word version). To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge
Tutorial at: http://www.wopr.com/index.php?showtopic=731107
or http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.
