Complex Mail Merge

[cougarCopyright]

Hi everyone - I have a database of songs, publishers, and their addresses. I
need to write them all a simple form letter seeking more information about
who owns the copyrights to the songs in my database. I want to do it with
one letter per publisher rather than one letter per song. This means that
some publishers will get a letter with the information for one song, while
others will get the information for ten songs (and a longer letter,
inevitably.) How can I make a mil merge that will list all the information
about the songs from each publisher on one letter?

 

[Doug Robbins - Word MVP]

You are trying to perform a "multiple items per condition (=key field)"
mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or at:

http://cornell.veplan.net/article.aspx?&a=3815

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[cougarCopyright]

Thanks for your help anyway. I'm not sure that the amount of publishers
justifies any overly complex solutions. I think I'll just custom format
each letter. There aren't too many of them .