Generate word documents from excel file using mail merge

Question

Hello

I am trying to generate word documents using the mail merge feature in Microsoft Word. To be as clear as possible my dream would be to:

(1) Place all values for all documents to be created in one excel document (2) Use Word to create a template by selecting the above excel file as the data sheet (3) Run a macro that would use the values from the excel sheet and perhaps the built in mail merge feature of Word to generate 1 file for each line in the excel sheet using one of the cells as the name of the file to be saved.

The end result would be the ability to create x number of Word documents using a template that pulls all the values from an excel sheet including the file name of the generated document.

Please help.

Thanks in advance.