Mail Merge Functionality

G

Gary

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
 
K

Kevin B

You would have to use the Next or Next Record field codes in your Word
document to capture the next row of data.

However, you'll be better served by posting questions on the Word Mail Merge
forum here a Microsoft's discussion group site.

Good luck...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top