Excel data into Word

[SamCallan]

I need to layout some data from excel into word. The final product needs to
have 5 columns so that it looks like (repeated across).

Name Name
Address Address
City, State ZIP City, State ZIP

I remember doing this years ago in Word, but I cannot figure out to do it.
I need to end up with 127 entries. This is for a page in a document. I seem
to recall that at the end of each merged entry, there was a code that told
word to enter the data going across rather than making a new page.

 

[Suzanne S. Barnhill]

Depending on whether you want the entries to go across and then down or down
and then across, you need either a label or a directory merge. Labels are
set up as a table, so they are filled across the table row. A directory
merge puts more than one record on a page, in a single column by default,
but you can format the mail merge main document to have more than one column
(five in your case).

If you need "labels," you can try to find a label definition that has five
across, but you may have to make your own, or just insert a five-column
table with the appropriate number of rows (with exact row height) and tell
Word to use that as the starting point for your "labels" merge.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org