I want to be able to click a button in excel which uses the data and then
turns it into an order letter. Most of the text is standard in the word
document so I want to set up a template with defined sections (or bookmarks)
where the data will go. On clicking this button it will open the word
document and input the cells into the designated places.

Any ideas how to do that?