Merging Excel data into Word doc from 2 sections of the same colum

[Darren Ingram]

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.

 

[Graham Mayor]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Darren Ingram]

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]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>