Button to open and print MSWord letter from Excel address book

[Islwyn]

Hi
I have an Excel sheet with names and addresses in a Worksheet and I want to create a button on a form which opens a Word document template (a letter) containing/linking the relevant fields etc. This seems a simple ask but I have had a trawl and came up with very little - I haven't even been able to find how to create the document without it being done step by step using a wizard.

What I would like to have is something like the following:
-----------------------------------------

Word template:

Excel-FileName-SelectedSheetName-FieldName1 [Name]
Excel-FileName-SelectedSheetName-FieldName2 [Address1]
Excel-FileName-SelectedSheetName-FieldName3 [Address2]
etc.

Dear Excel-FileName-SelectedSheetName-FieldName1

Bla bla bla

Yours etc.

----------------------------------

From a form in Excel I would like a button which opens this type of Word template filling the relevant fields based upon the drop-down (table) list selected in the Excel form.

Is this possible? If so, I would be grateful if somebody could tell me how to do it - and how to create the relevant Word template as all the 'how tos' on the web just seem to tell me how to do mail merge step-by-step rather than make a template with a permanent link to a table in an Excel file.

Many thanks in advance for your help.

Is

[Islwyn]

I think this has answered my question http://stackoverflow.com/questions/1...ord-mail-merge