mail merge with excel and word 2007

**newangel90** · 11-11-2010, 03:13 PM

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

**alansidman** · 11-11-2010, 07:42 PM

Please post a sample spreadsheet of what you have and what you hope to achieve. This would make it easier for someone on this board to help you. It is difficult to understand your issue without the visual.

Alan

**newangel90** · 11-12-2010, 02:20 AM

Hi Alan
thank you for your reply. I have attached the document. A note on the Word doc you will notice yellow highlights this is the information that must be completed by me using the database. The trouble I have is have one name on the 'claim' and listing all the awards. I would appreciate your assistance. thank you