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
Browse Related Skills
Other things people do on Freelancer
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