I'm on Excel and Word 2007. I'm a very inexperienced excel (and forum) user.

I have an excel spreadsheet that contains records in rows 1-1000. Columns are field types: Name, File, Dateclosed. The spreadsheet is sorted by Name, and each Name has multiple files and closed dates:

Name File Dateclosed
Fred 056 May
Fred 566 June
Fred 479 June
Norm 567 February
Harry 791 May
Harry 379 July
Harry 103 May


I'm sending form letters to Fred, Norm, and Harry. I'll send a form letter to each name. On this form letter I want to show a range of cells as a chart, which for Fred would be B2:C4 and for Norm would be B5:C5. The ranges will remain static- no new data will be entered.

The above chart is in an auxiliary worksheet- the sheet I'm using as the source for my mail merge has lots of other data.

I can create range names "fredchart" or "normchart", then use a DATABASE merge field, but that's no quicker than cutting and pasting. I want the list of file and dateclosed items for each name to behave as any other merge field- only difference being that it displays the range of data as a chart.

Hopefully that makes sense. Any input is much, much appreciated!