I think I'd spend some time looking at mail merge in MSWord.

Here are a couple of links:
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

BRENDA wrote:

I have set up personal data in columns that are titled classname, present
name, address, phone, email, occupation, children, grandchildren, interests,
etc. for a high school class reunion directory. How can I turn this into a
layout whereby it prints on pages and looks like this:

SMITH, Brenda (bold face and underlined)
COWELL, Brenda
3220 Main Street
Columbus, OH 43007
614-228-3223

Business Owner
Spouse: John Cowell
Tom (32), Bob (30), Sally (28)
Emily (7); Sammy (4)
Bridge, Reading, Tennis

If possible, I would like the layout to show two columns across the page,
such as:

SMITH, Brenda JONES, George
COWELL, Brenda JONES, George
3220 Main Street 579 Chester
Boulevard
Columbus, OH 43007 Albany, NY 45862
614-228-3223 253-954-7888

Can anyone help? I've been using Excel for the past year or two, but am no
whiz!
Thanks much.

--

Dave Peterson