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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.