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 In3 days
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
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online