I'm trying to copy company names, addresses (both street and email) and other information from a series of word documents into a single excel spreadsheet. This task seems somewhat similar to what is been done before, but I'm not sure if its merely relabeling file and folder names that would be required.
First, I have a folder on my computer called "customer", and in this folder there are other customer folders named "Mike Raphone", "Pat Metheny" and so on. Within each named customer folder, there is a word document with the information in it as in the attached "word doc info.jpeg"
What I'd like to have done is to have a macro or something that would go through all the customer folders in word, open the word documents therein, cut the company name, address, phone , email address(es), Invoice number and invoice date, and total service value pasted into the corresponding columns in the attached spreadsheet. The "service start date" in column T on the spreadsheet corresponds to the "service period" date in the jpeg as well.
Ideally, the macro or code should use the appliance number on the excel spreadsheet to match information on the "reference" box in the jpeg. I hope this is clear.
Thanks for any help you can provide.