Solved: Creating a Letter and Label in Word from Excel

[scott56]

I have developed a basic Excel utility that takes some Excel data and creates a word document populating the fields of data with values from the Excel workbook.....

I want to be able to create a single word document and populate each set of data to a different copy of the word template....at the moment when I run the attached samples it produces four (4) copies of the word template in the same document but it replaces the data with the last set of data at the end of the document.

Is there anyway to create a new copy of the word template in the same document and assign to it the next set of Excel data before looping through the rest.....or do I need to create a separate Word document for each copy of the word template that is required ?

Any help appreciated

Thanks
Scott

[scott56]

Has been resolved and now working....