You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...merge-Tutorial
or:
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it. For your purposes, see the topic titled 'Merging by Catalog/Directory to E-Mail'. Please read the tutorial's introduction!
Another approach would be to be to use a DATABASE field inconjunction with a normal letter merge and a macro to drive the process. For a recent solution along these lines, see:
http://answers.microsoft.com/en-us/o...1-1996c14dca5d
Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at
http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at
http://bit.ly/1hduSCB
In addition to a 'Many to One' merge, the latter handles:
• Merge with Charts
• Duplex Merge
• Merge with FormFields
• Merge with Attachments
• Merge to Individual Documents
• Merge, Print and Staple