[Nells]

I have a big excel document with loads of data and need to merge it to a form
that I have set up in word but it will not merge as I require it. I want 2
per page with columns - any ideas ?

Thanks

[Peter Jamieson]

If you mean you want the data for 2 records per page with 1 record on
the left and one on the right, you have two options:
a. lay out the page with 2 columns and put the data and fields you
want in column 1. Then insert a column break, a Next record field {
NEXT } field, then copy/paste the fields from the first column into the
second one
b. create the mail merge document as a "label" type merge and design a
custom label layout with a 1-row, 2-column table. Then go through the
usual process for a label merge (put the fieds etc. you want in cell 1,
then "Propagate labels" to fill in column 2 as needed.

(There isn't really that much difference between these two approaches).

If tht isn't what you meant, perhaps you could spell it out in a bit
more detail.

Peter Jamieson

http://tips.pjmsn.me.uk

Nells wrote:
I have a big excel document with loads of data and need to merge it
to a form
that I have set up in word but it will not merge as I require it. I
want 2
per page with columns - any ideas ?

Thanks