VBA code to copy and create n number of word documents from excel range

Hi all,

I am pretty new in VBA coding for word documents. I am trying to come up with a VBA code to copy and create n number of word documents from excel range (for example, say excel spreadsheet has 100 items in range A, i would like to loop through the range in column A and copy and create 100 word documents).

After creating say 1st document, i would like to loop through a particular row and fill the text form fields in newly created word document with the values in row 2. Say i have 20 columns with data for each item.

Any help will be greatly appreciated.

Thanks and regards,

Kon.

Hi
Post the excel file which has to be copied into word.