Create a VBA / Microsoft Office application to query a SQL database and populate a Word template

Scenario: We use a commercial product to manage properties and currently have to manually extract information on a regular basis to do a populate a Word document based on a template. This is extremely time consuming so are looking to automate this process. Details: The back-end to the product is a SQL Server database. As it is a commercial product we do not have access to the schema nor can it be modified. We already have the SQL query with the fields that we need to have populated in the Word document. It is anticipated the workflow will going something like this: 1. User opens the Word document template 2. Connection to the database 3. A dialogue box prompts the user to select the property from the database (or they can type the property number if they know it) 4. When the property is selected, the query is run on that primary key and results are returned from the database 5. The Word document is populated and returned to the user for further editing Objective: You will need to write VBA or equivalent using Word and Office to achieve this. The additional software footprint should be minimal for the workstation. Our company uses Office 2010. Resources: For this task, you will be given a login to our network with Remote Desktop Gateway and access to a workstation running Windows 7 with Office 2010 and access to a SQL Server.