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