Is it possible? I have a Word document with repeating blocks of information
for which I would like to use merge fields to insert data from an Excel
spreadsheet. Is there a way to merge multiple rows of info from Excel
(2007), each row's data merging sequentially into the info blocks in a single
Word document? e.g. Each row will have 5 columns with info: Lessor, Lease
Date, Document No., File Date, and Legal Description. The Word doc will have
repeating blocks as shown below and I want the data from row one to populate
the first block, row 2 the second block, etc., i.e.
Lessor: Merge field
Lease Date: merge field
Document No.: merge field
File Date: merge field
Legal Description: merge field