Concatenate IF column A matches, otherwise next?

[Lizabeta]

Eventually, I'm going to use Word and Outlook to email a mail-merged letter to 200 teachers.
I'd like to be able to group their data together rather than emailing them 30 one-line bits of info.

Can I use VBA to group together ... say columns B - G, several rows of data based on the teacher's name in Column A?

Alternatively, is there a way to do this without VBA? Maybe just a formula?

[abousetta]

Hi,

Could you post an example worksheet and what the expected result should be?

abousetta