Merging Multiple Records in One Document "Microsoft Newsserver" <nospam[ at ]nospam.com> 6/21/2007 2:10:15 PM Hi, I'm trying to replicate something similar to an invoice in a Word document via a mail merge. I'm selecting Directory as the document type and have a datasource with several records of line items. I would like to have some details appear only at the top (e.g. the person who is receving the invoice and their address which are merge fields, along with some static text) and then have the line items below that. The number of line items can vary from invoice to invoice. I've got a basic example working ok with the line items when I merge to a new document but I can't get it to just show the address block information (merge fields with some static text) only at the top and not repeated with every line item. For example I would like it to look something like this: Invoice # 123 To: John Smith 123 Smith St Smithville Date Descriptoin Price 1/6/2007 widgets 45.00 15/6/2007 banananas 55.00 Total 100.00 Does anyone know if this is possible in word via the mail merge and what steps I might be missing to accomplish this? Many thanks, Andrew

Re: Merging Multiple Records in One Document "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/21/2007 2:17:49 PM Word isn't very good at this (do it as an Access report if you can) but see the "Group Multiple items for a single condition" section on Cindy Meister's website at http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic or http://support.microsoft.com/default.aspx?scid=kb;en-us;211303 Peter Jamieson "Microsoft Newsserver" <nospam[ at ]nospam.com> wrote in message news:OmLYk3AtHHA.3504[ at ]TK2MSFTNGP06.phx.gbl... [Quoted Text] > Hi, > > I'm trying to replicate something similar to an invoice in a Word document > via a mail merge. I'm selecting Directory as the document type and have a > datasource with several records of line items. > > I would like to have some details appear only at the top (e.g. the person > who is receving the invoice and their address which are merge fields, > along with some static text) and then have the line items below that. The > number of line items can vary from invoice to invoice. I've got a basic > example working ok with the line items when I merge to a new document but > I can't get it to just show the address block information (merge fields > with some static text) only at the top and not repeated with every line > item. For example I would like it to look something like this: > > Invoice # 123 > > To: > John Smith > 123 Smith St > Smithville > > > Date Descriptoin Price > > 1/6/2007 widgets 45.00 > 15/6/2007 banananas 55.00 > > Total 100.00 > > Does anyone know if this is possible in word via the mail merge and what > steps I might be missing to accomplish this? > > Many thanks, > Andrew >