Ok so I am pretty new to writing code and the like. I have seen many similar questions but evertime I try and edit it for my leads, it doesn't work, probably because I don't know how to write the code correctly.

So heres what I need: I have a folder, well actually two but I could easily just cop one into the other(C:\Users\sales_000\Desktop\DW Order Forms and C:\Users\sales_000\Dropbox\DW Order Forms) that contains every order form I have ever created for my business.SAMPLE.DW.01.doc (Here is a sample)

I need a VBA code...Macro Whatever that loops through the folder and at the bare minimum, copies the email address and paste them into an excel workbook. What I would really like is for it to copy NAME, ADDRESS, PHONE and email address and create a contact in outlook and paste it all in. Not sure if thats doable but as a close second I would like for it to copy all the contact info and paste into different fields in Excel. I am 90% sure that is doable at least but if not, please somebody please write me a macro that copies the email into excel then closes the word doc or if thats not how this and you have to show me how to do it, please remember that I dont even really know the basic required form of a code that works or what syntax is or what it has to do with anything, It could also create a group or distribution list and I wouldn't be mad. Thanks!!!