One row per record. Each field in a separate cell/column. It's much easier to
combine fields than it is to separate them correctly.

You may want to read some tips for mailmerge:

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.

Nan wrote:

How to create names and addresses in EXCEL that can be used in a mail merge
in Word

--

Dave Peterson