Completed

Excel VBA to Word Merge

Hi, if you know Excel, Word and VBA, this one is easy! Here is the program flow:

1) User enters First Name, Last Name, Address, City, Province, Postalcode into Excel (columns)

2) Clicks a button "Create Letters" and for each row that has a column "Already Printed?" marked "No" it takes a Word Template and merges the fields in for the letter (address, name, etc.)

3) Opens one document with all the merges in it, whichever works best.

** Program then updates each excel - each row gets updated to show that (this can be in a new column) it was merged and a date goes beside it in a new column as well.

** Each word document should be time stamped unique

** Since the sheet will have more names added to it regularly, program should just scan for the first "no" and include all other "nos" and it should not delete or remove any rows.

** Program must work from within one folder only

That's it...probably not more than 2 hours at most.

Thank you.

Skills: Excel, Visual Basic, Visual Basic for Apps, Word

See more: excel vba word style heading, generate report word using excel vba, adding word excel vba, access mail merge vba, macro to populate a mail merge document from excel, excel macro mail merge word document, start mail merge from excel vba, word vba mail merge data source, mail merge vba code samples, excel mail merge without word, automate mail merge from excel, excel vba date format days, tableofcontentsadd excel vba word, excel vba staff leave report date leave type, excel vba script merge cells, excel vba mail merge pdf, vba mail merge excel 2010 word 2010, vba mail merge excel word, excel vba excel macro mail merge word, excel vba mail merge word document excel macro

About the Employer:
( 186 reviews ) Mississauga, Canada

Project ID: #17814348

Awarded to:

SBITServices

Hello ansales , Thanks for inviting me.I have read your project description and it is simple task. I have 5 years experience in Excel VBA programming. I can complete task within time with 100% accuracy. More

$20 CAD in 1 day
(368 Reviews)
7.3
sloker18

I am proficient with excel macro/VBA development, I can write the macro to perform the mail merge as specified, if you are interested feel free to message me, I am available to start your project immediately, looking f More

$30 CAD in 1 day
(45 Reviews)
4.9

10 freelancers are bidding on average $27 for this job

prasannjeetp

Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Awaiting your response. Thank you.

$30 CAD in 1 day
(32 Reviews)
4.1
paulodayto08

Hi Good day! A serious freelancer here! I have a lots of available time to this work. I can help you to complete this work. I am VBA Macro developer for 6 years now. I have a strong knowledge with Word a More

$20 CAD in 0 days
(9 Reviews)
3.1
TetyanaS

The examples of my codes you can see in my books. I'm the author of this book (VBA and VB .NET): [login to view URL] I conduct lectures and laboratory classes with students in the course “VBA and VB .NET”

$40 CAD in 3 days
(8 Reviews)
3.6
Mokshith30

Hi I am "VBA Developer". Expert in Web Scraping & VBA Macros.. Outlook Automation i can scrape any website.. & Python programming, Google Apps Script coding, Wordpress Developement, HTML, VB.Net I will do More

$25 CAD in 1 day
(5 Reviews)
2.3
Narasingamurthy

Hi Sir/Madam, We have expert in data services providing analysis and extracting website information using script language. data validating the outputs.

$25 CAD in 1 day
(0 Reviews)
0.0
jhrathod13

I am interested in your project. It would be great to discuss with you about your project. I am looking forward to hear from you soon.

$25 CAD in 1 day
(0 Reviews)
0.0
AhmedEzzat02

I am sure if you accept me, you will recieve a 100% accurate work on time without any delays and I am sure you will be happy and delighted.

$25 CAD in 1 day
(0 Reviews)
0.0
sssvinod

Hello, I am expertise in Excel VBA programming, let me know when can i start work and i can deliver with in the time as you are expecting.

$25 CAD in 1 day
(0 Reviews)
0.0