Hi George,

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version), but it isn't at all straightforward. 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...ngs-(2000-2010)
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.

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

Thanks for the reply.

I had reviewed the tutorial as part of my effort. It's relevance was lost on me in that I needed to create e-mail messages not a directory (I'm working in Office 2010) and that the data source is not readily manipulated. Have you been successful in generating single e-mails containing data from multiple records using your techniques?

Since my last post I've developed VBA code in Access to create a local table that contains a single record with data from multiple records in a linked table, using criteria specified in a Word userform. A test merge to e-mail showed that this table meets current requirements. (I have far greater experience with VBA than Word mergefields.) All that's left is to write the code to drive the merge.

g