Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
2003 mail merge - grouping question
Hi everyone,
I need to do a fairly simple mail merge from xl to word 2003. Where the excel data is stored in multiple lines per recipient. I've made up some example data below to better illustrate what I'm trying to do: Example (made up) excel data: Supplier Date Comments Inv # Amount £ DHL 20/7/07 blah blah 1 100.00 UPS 14/3/07 yeah yeah 20 200.00 DHL 27/11/07 yap yap yap 16 155.00 When I run mail merge, I get two documents for DHL, but I just want one ducument with two lines. Ie it should be in the form: Supplier DHL Date Comments Inv# Amount£ 20/7/07 blah blah 1 100.00 27/11/07 yap yap yap 16 155.00 I also need to insert a total. Any ideas how to group the data in this way? Thanks Richard |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
2003 mail merge - grouping question
Word is not really equipped to perform this type of merge, however, see How
to use mail merge to create a list sorted by category in Word 2002 - http://support.microsoft.com/?kbid=294686 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org richie wrote: Hi everyone, I need to do a fairly simple mail merge from xl to word 2003. Where the excel data is stored in multiple lines per recipient. I've made up some example data below to better illustrate what I'm trying to do: Example (made up) excel data: Supplier Date Comments Inv # Amount £ DHL 20/7/07 blah blah 1 100.00 UPS 14/3/07 yeah yeah 20 200.00 DHL 27/11/07 yap yap yap 16 155.00 When I run mail merge, I get two documents for DHL, but I just want one ducument with two lines. Ie it should be in the form: Supplier DHL Date Comments Inv# Amount£ 20/7/07 blah blah 1 100.00 27/11/07 yap yap yap 16 155.00 I also need to insert a total. Any ideas how to group the data in this way? Thanks Richard |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping records winthin a Winword mail merge | Mailmerge | |||
Mail Merge - Grouping/Sorts | Mailmerge | |||
Grouping data in mail merge | Mailmerge | |||
Mail Merge Grouping Levels | Mailmerge | |||
Word 2003 and Access 2003 Mail Merge question | Microsoft Word Help |