Macro: Save Mail- Merged Doc to current Directory

I have a workbook with many worksheets. On one sheet (named "Word_Letters") I have set up the source data for mail merge documents created in Word.

I want to create a macro and assign it to a button on the "Word_Letters" sheet that will execute a mail merge and save the resulting document in the same directory as the active workbook.

The word document is named "Failure to Agree.docx." and stored in the following directory: S:\APPRAISAL SHARED FOLDER\Mail Merge\Word Templates

My knowledge of macro writing is limited to copying VBA and pasting...thanks in advance.

Oh, I also would like to leave the word doc open for editing and review.


Thanks again