Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Complex Mail Merge
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Complex Mail Merge
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/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;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" wrote in message ... 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? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Complex Mail Merge
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 . "Doug Robbins - Word MVP" wrote: 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/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;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" wrote in message ... 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex Mail merges | Mailmerge | |||
A complex question on setting up a mail merge. | Mailmerge | |||
Complex Mail Merge using Directory Document Source | Mailmerge | |||
Complex merge | Mailmerge | |||
Using VBA to merge complex data | Mailmerge |