Thread: mail merge with Excel and Word 2007

Hi

I am attempting to run a mail merge using an existing excel list.

I am needing to write successful letters to students communicating their results on scholarship. Some students may have 3 the other may have 6 which results in the student appearing that many times on the spreadsheet.

i have a claim document which th student must return to me for payment but, i am needing to merge all the scholarships to one student on this one claim.

please could anyone help me to fix this.
thank you

As far as I'm aware, you need one record in your excel book per merged letter, so the problem then becomes one of converting a table with up to 6 entries per student into one with only one entry per student, and perhaps a column for each scholarship. Can you give us a sample spreadsheet?