Copy Data From One Word Document To Another

[jo15765]

We have about 3,000 word documents that are tailored to specific Customers, and well...we need to update some of the verbiage. The data that makes it customized to that specific customer is in either a text box or table.

Using access vba how can I
1) Open customer1.docx
2) Open template.docx
3) Iterate all text boxes and tables on customer1.docx and paste into the same table/textbox on template.docx
4) Close customer1.docx


5) Move customer1.docx to archive folder
6) Save template.docx as customer1.docx

[ssanfu]

If I understand correctly, you are wanting to automate Word using Access?
You are wanting to use Access because the names of the documents/Customers and the updated verbiage are in 1 or more Access tables?


So you have "about 3,000 word documents". Does that mean you have "about 3,000 specific (unique) Customers"?

Or each "specific Customer" has 1 or more word documents? Customer1 might have 1 document, whereas Customer2 might have 5 documents?

If a "specific Customer" has more than 1 document, are all documents modified the with the same verbiage?


I would probably start by recording code (Word calls it a "Macro" like Excel), then figure out the changes necessary to convert the Word code to Access code.

I did a quick search and found a YouTube video about "Word Macros" and a site of Word Macro Examples & VBA Tutorial.

[Welshgasman]

Why not just copy and rename?

[moke123]

Is this a one-off excersize or something to be done repeatedly?

Have you looked into word merge?
Albert Kallal has a great application, Super Easy Word Merge- http://www.kallal.ca/msaccess/msaccess.html

[jo15765]

This is a one off excercise.

The data does not exist in access tables. The data literally only exists in the word document. I was wanting to use Access to do it as I could create a button to visually update/display progress to the user (as this process will be performed by 5 - 6 different people with the same amount of word documents to update.