Hi imogul,
A Word mailmerge document can only work with a single data source, so that would require all the relevant Excel data to be consolidated into a single workbook. The alternatives are to:
• employ a DATABASE field that your mailmerge main document can direct the merge to each of the Excel workbooks using a field in a 'main' workbook; or
• do something with vba
but, without knowing the structure of the workbooks and whether they're suitably structured for this, I can't give any advice on how you would do that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|