Create Multiple Word Files from Template with Excel Inputs

Hello,

I'm facing one situation.

I have customized one MS Word template for Part specifications.
I have a long list of Parts in an Excel for which I need to create Part Specifications in Word, each with it's own specification document.
I work with Excel VBA on & off but never worked with interfacing of Word & Excel.
Here's my specific requirement:
1. I Open my List of Parts in Excel
2. Run the Macro.
3. Macro Asks for the First Reference Row
4. The Macro seeks the Word template.
5. Creates a file -> New from Existing with this Template
6. Inserts Data from the Excel Reference Row to specified location in the newly created word document.
7. Performs a 'Save As' on the newly created Word Document & Renames it with specified data from the reference row in Excel.
8. Moves on to the next Row in Excel.
9. Repeats 4-8 until the range A'i' is empty.

I've been trying to work on the macro, but it's turning out to be a nightmare (I'm still a beginner) & I have to finish the list this week. I'd really appreciate the help.

Thank you,

Cheers,
Gajanan

Hi Gajanan,

Have you tried using Word's Mailmerge feature to achieve this? This will merge data from each of the Excel rows (which can be filtered) into one large Word document (one copy of the template for each row in the spreadsheet).

Then, you can use the macro from the second post on https://social.msdn.microsoft.com/Fo...dividual-files to split the large Word document into separate ones.

Larena