If this is for multiple documents, then obviously, mailmerge is the way to
go and that does require that the information for each record be on the one
row.
If it is just a single document that is being produced, you could either
paste links to the cells in Excel or use automation.
See the article “Control Excel from Word” at:
http://word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm
or “Control Word from Excel” at:
http://word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm
--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP