I am using data in one excel spreadsheet to create a mail merge
document.

I have another excel spreadsheet with salary breakup data for each of
the employees in the first spreadsheet (one row of data for each
employee in first spreadsheet and in same order).

When I do the mail merge I am using data from the first spreadsheet to
populate name and other personal data.
I want to use data from the second spreadsheet to draw pie charts (in
the merged document) for each employees salary breakup.
But when I run the mail merge I get the salary breakup data from only
the first person's row (from the second spreadsheet) appear for all the
employees in the merged document.

If this is not possible using Word 2000, is there any other word
processor capable of doing this ?

Thanks in advance.

------------------------------------------------