Excel Macro to Generate Word Document

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

Hello,

I am looking for some help to take data from an Excel spreadsheet and create a Word document from it. I assume a Macro button is the best option but I am open to other solutions.

I have a list of ~1500 contacts that I would like to generate letters for.

I need to take some information, like names, addresses, etc and put it into the letter. Additionally there is nine conditional elements, based on the data in the speadsheet, that will determine if certain paragraphs are included. Some of these are simple, such as if value not equal zero, include paragraph with that value. Some of the others are more complex, such as if 2E is included than include paragraph (example - 2G2J2K2T2E3D3H2F, codes may not be in alphanumberic order. Codes are always 2 digits).

I need today's date, a future date, company name, company address (may be 2 lines), company city, state, and zip, contacts first name, and conditional elements to be included. The template is written and I will provide, if you think you can do this. Attached is a copy of a sample Excel file containing the data I need to be included. Please create a macro that I can use on my ~1500 line excel file. I will not be providing the large file so I will need instructions on how to install into my file.

Thanks!

Data Processing Excel Visual Basic Visual Basic for Apps Word

Project ID: #16190927

About the project

10 proposals Remote project Active 6 years ago

Awarded to:

developer287

i am expert vba visual basic for application programmer. i can make this script for you now and i can start now. it will extract these data from the excel sheet and save all the new word letters for you. i need a sampl More

$10 USD in 0 days
(7 Reviews)
3.7

10 freelancers are bidding on average $26 for this job

elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$50 USD in 2 days
(338 Reviews)
7.5
bilalmaher053

hi, can you send me word format in chat?

$30 USD in 1 day
(304 Reviews)
7.1
Abubakar121121

Hi,Sir I am interested in your project if you want to hire me kindly reply me.i will do your work with full perfection and on time.

$15 USD in 1 day
(5 Reviews)
1.8
ThatAwesomeTutor

. I am a detailed and thorough professional with 5 years of administrative experience- the last 5 years in academic writing and virtual office environment. I specialize in delivering quality services with respect to st More

$25 USD in 1 day
(0 Reviews)
0.0
ikramsahir

I believe my words.

$35 USD in 2 days
(0 Reviews)
0.0
Shobonet

A proposal has not yet been provided

$30 USD in 3 days
(0 Reviews)
0.0