Hi Adam,

Mailmerge wont work for the following reasons:
• A mailmerge can only accept one worksheet as a data source
• To link to a chart, you'd need to embed a MERGEFIELD inside a LINK field. Unfortunately, as soon as you do that and update the LINK field, it's contents get resolved to text - and the MERGEFIELD gets deleted.
• The fact you have both charts and data in the workbook suggests there's one workbook per student. Mailmerges are designed to work with situations where all the student records are in the same workbook.

Assuming the last point above is correct, then provided your workbook's worksheet and chartsheet names are consistent, a macro can interrogate each of them easily enough without anything to match within each of them. If all the Excel workbooks are in a common folder, a macro could easily enough loop through all files in the folder to produce a report for every student in one go - and save the reports to whatever location you want.

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