Closed

Excel Spreadsheet to merge row data to MS Word - Repost - open to bidding

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: Data Processing, Excel, Software Architecture

See more: mail merge word from excel, excel mail merge to word, excel mail merge template, architecture review template, vba for word, excel vba or, excel 2013 vba, word template, word merge, vba word, vba projects, row spreadsheet, row b, ms excel template, MS Excel projects, merge data, mail merge, excel spreadsheet, excel or word , excel automate, excel and word project vba, data merge, bidding functions, word merge excel, word merged

About the Employer:
( 0 reviews ) Ungaran, Indonesia

Project ID: #5050875

22 freelancers are bidding on average $373 for this job

Toperfection

Dear "rega7" Hope you are doing well. I have reviewed the project details and would like to offer our services. We have completed many Research/Data collection/Product add/Data mining assignments on [url removed, login to view] a More

$277 USD in 4 days
(36 Reviews)
6.6
diamond247

Hello Sir, We are a big set up company with excellent skilled operator who have a lot of experience in this segment, our employee complete more than 300 similar job, i have gone through your project specification, i More

$250 USD in 3 days
(64 Reviews)
6.4
happy2helpp

Respected sir, Experts here!!! We saw project description and got complete idea about project. We are expert in Data Entry, Data Mining, Data Processing, Web Search and Web Scraping!!! We have worked on many similar More

$263 USD in 4 days
(39 Reviews)
5.8
FIBIN

“Excel is my passion & and I guarantee quality work in minimum time” Hi I am an expert in Excel and VBA Programming in Excel. I have experience in Excel Designing, Excel VBA Programming, Providing Business Sol More

$250 USD in 2 days
(45 Reviews)
5.3
satsin7

Hello Sir, Everyone uses MS excel, some more some less. Most people do not realise the immense potential of excel. I'm a passionate excel user and I like your innovative thinking in putting excel to use for simplify More

$250 USD in 3 days
(20 Reviews)
4.7
PulseLab

Hi, If your version of Excel (and Word) is 2007 or 2010, I could create an Excel add-in for you that would do this. This would add an extra button or two to your toolbar at the top of Excel. When you click on a cell More

$444 USD in 5 days
(3 Reviews)
3.9
bmartynvw

I'm a Microsoft certified developer with 18 years of experience. I have good experience with the exact requirements you have. I can ensure that when you click on a cell in Excel, the data from the row is automatically More

$318 USD in 5 days
(7 Reviews)
3.8
AndroidAll

Dear Sir, I'm interesting in your job. I have much experience in the MS Excel, Word and VBA. I can do this job. You didn't attach the spreadsheet sample. I want you attach it. Regards. PS. In order to show More

$556 USD in 3 days
(5 Reviews)
3.5
inoussakabore

Hi my Dear, I master excel, word and VBA. I have already done an application where excel and word interract. I want to do this job for you.

$526 USD in 3 days
(2 Reviews)
3.3
drevak

---------------------------------------Consider it done....done professionally!---------------------------------------

$300 USD in 7 days
(3 Reviews)
3.0
anuyadav1

i can make it exactly as you have described to send client mail by reviewing the template ...........

$277 USD in 3 days
(2 Reviews)
2.8
MasterExcel

I am Data Entry ,MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high More

$526 USD in 3 days
(6 Reviews)
2.7
rpedersen360

I am able to create two combo boxes, one to pick which client to send the letter to, and one to select which letter to send, and a button to run. When the button is clicked, it will open a new instance of Word, to More

$250 USD in 2 days
(3 Reviews)
2.3
BenMoorhouse

Hi Rega7, My assumption from your description is that you will have a number of different templates set up. This wont be a problem at all. There would be a sheet listing all of the clients, another sheet listing More

$400 USD in 2 days
(2 Reviews)
1.6
tocprashant

i am professional information and data maker with a team of 10 person excelling the same field. i assure you with the perfection and job satisfaction on your end.

$250 USD in 2 days
(0 Reviews)
0.0
procodian

Hi! I will just give you a brief introduction of myself and the relevant experiences that I can bring for this project: - Master of Science in Software Engineering from Sweden (more than happy to email you a co More

$394 USD in 7 days
(0 Reviews)
0.0
amarbhaw

Hello, We checked your requirement and Rather than telling you we will provide the quality work we prefer you to decide after checking our portfolio at [url removed, login to view] also if you wish you can add amarb More

$721 USD in 7 days
(0 Reviews)
0.0
brucknerk

Good Day, I was previously employed (15 yrs) in an investment/treasury environment where we managed our clientbase (in excess of 3000 clients) also using Excel. I am familiar with using Excel and mail merging person More

$388 USD in 5 days
(0 Reviews)
0.0
vsevolodeu

Hello, Sir I have more than 10 years experience in software development (t-sql, c#, objective-c, VB) and can easily accomplish the task. More over I have a very good motivation because I'm new on this site. Please, More

$533 USD in 7 days
(0 Reviews)
0.0
harryct

Hi there, I am an Excel expert and award-winning VBA code writer. I have over 7 years' experience in creating bespoke Excel and VBA solutions in global companies, research organisations and the public sector. Ba More

$388 USD in 3 days
(0 Reviews)
0.0