Excel Spreadsheet to merge row data to MS Word

This project was successfully completed by koolsidz for $250 AUD in 3 days.

Get free quotes for a project like this
Project Budget
$250 - $750 AUD
Completed In
3 days
Total Bids
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

Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online