Repeat macros in a loop and save as word files

Hi,
I have 2 files...one is an excel and other word.....

In the excel file (customer data) i have the following fields :-

Name
Address 1
Address2
Phone
Mobile

in the word file (letter) i have created the bookmarks to replace from the excel file
and everything works fine.....

it copies and replaces the data from the first row and opens the word file.

HERE IS WHAT I NEED TO DO AFTER THIS :-

once the data is copied from excel to word i need it to save the word file in a folder
and then go back to the excel file and do the same for next row of values and save it as a different file.

the word file names need to be the name from the excel file if possible.

i have uploaded the files...please have a look and help me resolve this...

This is the macro code :-

Please Login or Register  to view this content.

Awaiting a reply impatiently ....
let me know if any further clarification is needed... THANKS A TON IN ADVANCE

Hi, you need to fix your title and use code tags as per forum rules first.