Export data to a word template

Hi

I am trying to export data from a spreadsheet to generate a report in word. The word report is in a standard form and data from excel should populate certain paragraphs within it.

I have been reading a book by Richard Sheppard but cannot implement what he writes.

The data exported will be from a drop down menu and be a like for like basis, so if the drop down menu states 'Yes', then 'Yes' should appear in the word document.

If someone could show me an example of VBA code that would achieve this I would much appreciate it.