I need to make a form letter but the info I need is not in a convenient list. I was given 50 spreadsheets and word docs. The word docs contain the name and address, the spreadsheets contain dollar figures. Is there anyway to merge this all together? Some kind of mail merge macro maybe? Or should I try to import all this stuff into a separate document first to create a source doc? I'm kind of lost here. Any advice you guys could give me would be appreciated.

Thanks

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]