Merging Excel data into Word doc from 2 sections of the same colum Darren Ingram 11/20/2008 2:51:03 PM I have a Word document that is laid out in table form. I then import the information from Excel into the table. (this is easy) The table was small enough that I was able to place two on the same A4 page and have one record printing after another.... (saving paper) (Also easy) When I cut the pages in half and sort the documents alphabetically to create one pile (with 140 client docs) this is a time consuming process. What I want to do is to insert Client 1 on A4 page 1 (top table) and Client 2 on A4 page 2 (top table) etc etc up to Client 70 on A4 page70.... I then at the same time want to print Client 71 on A4 page 1 (bottom table)and Client 72 on A4 page 2 (bottom table) etc etc up to Client 140 on A4 page70. Then when I cut the pages in half I don't have to sort.... (saving time). I'm not sure how to do this....please help.

Re: Merging Excel data into Word doc from 2 sections of the same colum "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 11/20/2008 3:13:51 PM Either create two separate merge documents - one containing only the top table and the other containing only the bottom table and merge the first 70 records on the first merge and the second 70 on the second merge. Merge one to the printer, replace the paper and merge the other. or better still, re-order your data source to give you the required order and complete the merge. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Darren Ingram wrote: [Quoted Text] > I have a Word document that is laid out in table form. I then import > the information from Excel into the table. (this is easy) > > The table was small enough that I was able to place two on the same > A4 page and have one record printing after another.... (saving paper) > (Also easy) > > When I cut the pages in half and sort the documents alphabetically to > create one pile (with 140 client docs) this is a time consuming > process. > > What I want to do is to insert Client 1 on A4 page 1 (top table) and > Client 2 on A4 page 2 (top table) etc etc up to Client 70 on A4 > page70.... > > I then at the same time want to print Client 71 on A4 page 1 (bottom > table)and Client 72 on A4 page 2 (bottom table) etc etc up to Client > 140 on A4 page70. > > Then when I cut the pages in half I don't have to sort.... (saving > time). > > I'm not sure how to do this....please help.

Re: Merging Excel data into Word doc from 2 sections of the same c Darren Ingram 11/20/2008 5:53:01 PM Thanks for the reply Graham, but it wasn't what I wanted. I'm not sure if I explained it well enough. My data in excel is Surname (col A), First name (col B)....there is more but for sake of simplicity that will be enough. 140 client in alpha order surnames sorted from A-Z . On my Word document I have two tables (because they are small enough) with table one at the top(with client 1 data) and table two at the bottom (with client 2 data). Lets use 4 surnames as an example: Adams, Adamson, Alexander,Allen. So when I run the current mail merge it puts Adams (table 1 page 1), Adamson (table 2 page 1), Alexander (table 1 page 2) and Allen (table 2 page 2). Now I use these tables as header pages for files, so I cut them in half and sort the two piles into correct alpha order again.... I know it seems simple when there is only 4 clients but with 140 the time to resort my piles into 1 pile from A to Z is time consuming... Hence I want Client 1 to 40 on to top table of every page and clients 71 to 140 on the bottom table of the same A4 page. So that when I cut the pages in half I just put one pile on the other and they are all sorted. I hope this is a little clearer... "Graham Mayor" wrote: [Quoted Text] > Either create two separate merge documents - one containing only the top > table and the other containing only the bottom table and merge the first 70 > records on the first merge and the second 70 on the second merge. Merge one > to the printer, replace the paper and merge the other. > > or better still, re-order your data source to give you the required order > and complete the merge. > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >

Re: Merging Excel data into Word doc from 2 sections of the same c "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 11/21/2008 6:43:11 AM It was clear the first time and the original reply suggests the two methods to do that. You either re-arrange your data to put it in the order needed to merge into the current document or you create two half documents (one with table 1 the other with table 2) and merge them separately on to the same piece of paper. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Darren Ingram wrote: [Quoted Text] > Thanks for the reply Graham, but it wasn't what I wanted. I'm not > sure if I explained it well enough. > > My data in excel is Surname (col A), First name (col B)....there is > more but for sake of simplicity that will be enough. > > 140 client in alpha order surnames sorted from A-Z . > > On my Word document I have two tables (because they are small enough) > with table one at the top(with client 1 data) and table two at the > bottom (with client 2 data). Lets use 4 surnames as an example: > Adams, Adamson, Alexander,Allen. > > So when I run the current mail merge it puts Adams (table 1 page 1), > Adamson (table 2 page 1), Alexander (table 1 page 2) and Allen (table > 2 page 2). > > Now I use these tables as header pages for files, so I cut them in > half and sort the two piles into correct alpha order again.... > > I know it seems simple when there is only 4 clients but with 140 the > time to resort my piles into 1 pile from A to Z is time consuming... > > Hence I want Client 1 to 40 on to top table of every page and clients > 71 to 140 on the bottom table of the same A4 page. So that when I > cut the pages in half I just put one pile on the other and they are > all sorted. > > I hope this is a little clearer... > > "Graham Mayor" wrote: > >> Either create two separate merge documents - one containing only the >> top table and the other containing only the bottom table and merge >> the first 70 records on the first merge and the second 70 on the >> second merge. Merge one to the printer, replace the paper and merge >> the other. >> >> or better still, re-order your data source to give you the required >> order and complete the merge. >> >> -- >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >> Graham Mayor - Word MVP >> >> My web site www.gmayor.com >> Word MVP web site http://word.mvps.org >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>