Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mail Merge Functionality
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mail Merge Functionality
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... -- Kevin Backmann "Gary" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge | Excel Discussion (Misc queries) | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
mail merge | Excel Discussion (Misc queries) | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) |