Generate Multiple Word Documents from Multiple Excel Files
Hello, I'm new here and am looking to reduce the amount of menial office data entry I have.
Every client has an excel file with their customer ID number, and from this I have to manually copy and paste data into 3 different word templates. The excel files are all formatted identically.
I have tried linking excel data into the word templates, and then changing the source whenever I want to make the document for a new client, but this is a pain because updating the data changes the formatting and I need to fix it enough that it becomes the same amount of work as copy/pasting. I've also looked into Mail Merge, but this generates multiple word documents from one excel file directory. My case is 1 excel file --> 1 word file. Is there a way to do what I'm looking for?
One word template takes a table from the excel file and places it on a certain line, centering it.
Another word template does the same, but also takes two more single cell values
The third is a word table with pictures, with certain rows only present if they are checked on a checklist in the excel file, otherwise they are deleted.
So is there a way to have a word template where I can simply tell it to take data from a certain excel file, it populates automatically in the desired format, and I can hit print?
Is there a way to do this for multiple files at once, like a folder of 10 excel files? Is there a way to write a program that does this, because I would be willing to use my limited coding knowledge if someone would be willing to help me.
Thank you for your time.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By NicoleAL123 in forum Excel Programming / VBA / Macros
Last Post: 11-13-2017, 10:43 AM
By X82 in forum Excel Programming / VBA / Macros
Last Post: 09-26-2016, 09:45 PM
By 10degrees in forum Excel Programming / VBA / Macros
Last Post: 08-26-2015, 12:34 PM
By NYC4LIFE in forum Excel General
Last Post: 01-10-2014, 02:33 PM
By Milan Kotus in forum Excel Programming / VBA / Macros
Last Post: 11-14-2013, 12:07 PM
By Wende in forum Excel Programming / VBA / Macros
Last Post: 07-10-2013, 11:22 AM
By lwaldron in forum Word Programming / VBA / Macros
Last Post: 10-02-2012, 05:34 AM
Tags for this Thread
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1