updating data in MS Word document

[minnman]

I have an Excel spreadsheet that contains data that I am trying to write to MS word documents. Basically, if there are 10 rows of data in the spreadsheet then I must create 10 new Word documents. All of the wording in each Word document is the same. Only the data changes. I have created a Word document and bookmarked the places where each relevant data should be inserted. I would very much appreciate any help on how to write the VBA macro. I have code which will loop through the rows in the spreadsheet but need help with opening a Word doc, updating the bookmarked places with data, and closing the document. Thank you very much in advance to anyone offering to help.

 

[Norie]

Why not just use Word mail merge?

 

[minnman]

Thanks very much for your response.
I didn't know that Word mail merge could do that.
The source spreadsheet may contain a few hundred rows of data which means I will end up with the same number of Word documents. Each Word document must have a name that consists of two of the columns on the row. Can Word mail merge do that?