I work in a school. I have imported data into an Excel spreadsheet which
contains student courses and grades. I need to print one label for each
student that contains their courses and grades. Since the information
imported the courses and grades in separate colums and separate rows, my mail
merged labels are printing a different label for each course for every
student. I want to combine the list of courses and grades so that each
student will have only ONE LABEL that contains all their courses and grades.
How is this done? Our school system uses Excel 2003.

Can't see your layout, but mailmerge likes to see all info for each label
across one row.

Assuming you are using Word for the mailmerge and Excel for the source see
these sites for help.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Wed, 19 May 2010 07:18:02 -0700, NCWISE
wrote:

I work in a school. I have imported data into an Excel spreadsheet which
contains student courses and grades. I need to print one label for each
student that contains their courses and grades. Since the information
imported the courses and grades in separate colums and separate rows, my mail
merged labels are printing a different label for each course for every
student. I want to combine the list of courses and grades so that each
student will have only ONE LABEL that contains all their courses and grades.
How is this done? Our school system uses Excel 2003.