mailmerge with columns

N

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
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top