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.