I have approximately 1,800 folders each in the name of a client. Within the folder is one word document with the client's address listed as a letter. I need to create an excel list of the names and addresses so I can mail merge all of them. I have attached an example document to help explain.
Any help would be greatly appreciated otherwise I will be manually going into 1,800 folders and opening up the word document and copying and pasting into excel!!!!!!!
Many thanks in advance.
Alex
Bookmarks