Discussion:
Trying to merge a list of names into a Word document
(too old to reply)
darkwing_duck
2011-05-05 00:27:52 UTC
Permalink
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's 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 can't figure it out. Whenever I try the mail merge, it only merges
the first name, I can't figure out how to merge the rest of the 600
names.

Help?

Thanks.
Suzanne S. Barnhill
2011-05-05 12:17:10 UTC
Permalink
To get the order you ask for, you're 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've propagated the labels, you'll 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
Post by darkwing_duck
Using MS Office 2002.
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
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 can't figure it out. Whenever I try the mail merge, it only merges
the first name, I can't figure out how to merge the rest of the 600
names.
Help?
Thanks.
Loading...