Excel Spreadsheet to merge row data to MS Word

IN PROGRESS
Bids
49
Avg Bid (AUD)
$320
Project Budget (AUD)
$250 - $750

Project Description:
I use an Excel Spreadsheet to manage client projects. See attached spreadsheet example.

Each line is a different client's project. At various stages of the project process, I need to send letters to my clients. For example, 2 weeks after beginning a particular project for a client, I need to send them a personalised letter (Letter A) informing them of the status of their project. Then a few weeks later, Letter B needs to go out.

I want to automate this process so that I can look at my spreadsheet, see the Client X needs to be sent a letter, click on Client X's cell (or somewhere) which then brings up the merged MS Word document for me to review.

This is not a mail merge, per se, because a) I want to open a particular MS Word template from Excel, not Word, and b) I only want to open one client's letter at a time, not a mass mailing. I'm not sure if this can be set up, though, using mail merge, VBA(?), or bookmarks....

So the functions required from within the Excel Spreadsheet are:
-Chose which MS Word template to launch
-Chose which client (ie. row) I want to merge data from
-The MS Word doc that opens is to be named according to data from one of the cells in that row

Skills required:
Data Processing, Excel, Software Architecture
Additional Files: -=TM Database =- 17.10.13.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 250
in 3 days
$ 250
in 3 days
$ 250
in 3 days
$ 300
in 3 days
Hire mrbrave
$ 263
in 2 days
$ 250
in 3 days
$ 263
in 6 days
$ 277
in 7 days
$ 250
in 1 days
$ 270
in 10 days