Copy each excel row to new word document

Hello All,

I am trying to create a program that will interact with word exclusively. My company uses specialized reports called BIPs. These reports are normally in individual word documents. However, a different company has taken all of the BIPs and put them all in to one excel spreadsheet. Now, my boss wants me to take all of the information and hand copy and paste each one back into a word document. This is time consuming, as there are thousands of them in this excel spreadsheet, and this could be something we run into again.

I know there is a way to get excel to put the reports back into a word document, but I can't figure it out.

Each column has a header which is the name of a section of the BIP. So, what I need to do, is scan each row (A-R), and assign each cell to a string (Let ReportNumber = A2.text, etc.), starting with the second row. Then, open a new word document and put each of these strings into it, inserting the column header before each string. Then, save the word document in my documents as the report number. It needs to loop to the next row, until there are no more rows to scan.

I feel like this is easy enough, but I can't figure it out. Mainly because I don't know how to get excel to interact with word this way.

Thank you for any help.

Hi..

Upload a Workbook with all Columns same as your real workbook.. maybe just include 5-10 rows of data...

Click the "Go Advanced" button to access the Attachment function..

Question: Did you want each String (Cell data) placed on a new line in the Word doc?