Word - Trying to merge a list of names into a Word document

Asked By darkwing_duck on 04-May-11 08:27 PM
Using MS Office 2002.

I have a list of names in Excel as:

Column A     Column B       Column C
FirstName    MiddleName   LastName
John            Smith             Doe
Sally            May               Johnson
Mark            Bob               Thompson
Bruce           Alex              Boudreau
Marcus        Michael          Johns
Elizabeth     Anne             Williamson

... and so on to the bottom of the list

I want to merge that list that is 3 columns wide in Word to read like:

John Smith Doe             Sally May Johnson             Mark Bob
Thompson
Bruce Alex Boudreau     Marcus Michael Johns        Elizabeth Anne
Williamson

... and so on to the bottom of the list



I thought for sure the way to do that was by way of a mail merge, but
I cannot figure it out.  Whenever I try the mail merge, it only merges
the first name, I cannot figure out how to merge the rest of the 600
names.

Help?

Thanks.


Suzanne S. Barnhill replied to darkwing_duck on 05-May-11 08:17 AM
To get the order you ask for, you are going to need to merge the names into a
three-column table rather than snaking columns. The easiest way to do this
is to use a label merge since it will automatically insert the needed (and
only the needed) ?Next Record? fields (labels are set up in table format).
After you have propagated the labels, you will see only one page until you
actually complete the merge.

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