I'm using Office2000 with Excel as a simple database for some home stuff. I enabled the ODBC driver of excel and MS Query in case I need them.

What I want is a mail merge in Word using a Excel spreadsheet as data source. There is no problem if I use it the ordinary way (one record produces one letter). However sometimes two records are related and need to be in the same letter.

For example, the spreadsheet contains columns: Singer, Song, Year. There will be more than one song per singer. Now I want all songs of one singer printed in a letter using mail merge.

Is that possible (if so, how?) or is this a limit when using Excel as DB.

I googled and used Office Help but didn't find an answer.
BTW, is this the right forum to ask this question?