Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word MailMerge - repeat some fields if next row same Client
I'm trying to mailmerge from Excel 2003 into Word 2003.
Each client could have 1 or more records. I want one letter for each client, displaying each of the items and an amount in a tabular format eg. Mr X Item No Amount 1 10.00 2 20.00 I have tried using {Next Record If} but am getting spurious results. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word MailMerge - repeat some fields if next row same Client
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 http://www.knowhow.com/Guides/Compou...poundMerge.htm -- 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 "Turbo_Shark" wrote in message ... I'm trying to mailmerge from Excel 2003 into Word 2003. Each client could have 1 or more records. I want one letter for each client, displaying each of the items and an amount in a tabular format eg. Mr X Item No Amount 1 10.00 2 20.00 I have tried using {Next Record If} but am getting spurious results. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word MailMerge - repeat some fields if next row same Client
"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 http://www.knowhow.com/Guides/Compou...poundMerge.htm -- 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 "Turbo_Shark" wrote in message ... I'm trying to mailmerge from Excel 2003 into Word 2003. Each client could have 1 or more records. I want one letter for each client, displaying each of the items and an amount in a tabular format eg. Mr X Item No Amount 1 10.00 2 20.00 I have tried using {Next Record If} but am getting spurious results. Thanks Doug - I don't think this warrants the pain of working out the If statements. Going to cross tab the source data then have [Item1], [Amt1], [Item2] [Amt2] etc... Think they only have max 4 rows so easier to suppress blank fields. As a database developer it is quite frustrating to find that Word does not support this type of functionality. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word MailMerge - repeat some fields if next row same Client
As a database developer, I would use a report to produce the result.
-- 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 "Turbo_Shark" wrote in message ... "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 http://www.knowhow.com/Guides/Compou...poundMerge.htm -- 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 "Turbo_Shark" wrote in message ... I'm trying to mailmerge from Excel 2003 into Word 2003. Each client could have 1 or more records. I want one letter for each client, displaying each of the items and an amount in a tabular format eg. Mr X Item No Amount 1 10.00 2 20.00 I have tried using {Next Record If} but am getting spurious results. Thanks Doug - I don't think this warrants the pain of working out the If statements. Going to cross tab the source data then have [Item1], [Amt1], [Item2] [Amt2] etc... Think they only have max 4 rows so easier to suppress blank fields. As a database developer it is quite frustrating to find that Word does not support this type of functionality. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Reveal codes in a word document | Microsoft Word Help | |||
hard space between words. | Microsoft Word Help | |||
Converting Word Perfect forms to Word forms | Microsoft Word Help | |||
In Word, how can I see all files (*.*) in "save as"? | New Users |