Unanswered: Mail Merge with two records in one form
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?