I am wanting to extract word archives from 1999 to 2015 the following into Excel for the purpose of create Access databases of 1000s of pieces of information.
1. Subject: Ad Removal November 20 <database of subjects
2. From: John Smith, Project Engineer <database of senders
3a.Personnel: Ron Wolf, Pacific Advertising <database of contractors
3b. security clearance: Yes or No
Note, I have create PDF copies per year 1999 to 2015 and converted PDF of 2015 into Word thinking I could then extract all the specific information using a Word Macro but recording Macros have issues with copy & paste.
My first post,![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
1. Subject: Ad Removal November 20 <database of subjects
2. From: John Smith, Project Engineer <database of senders
3a.Personnel: Ron Wolf, Pacific Advertising <database of contractors
3b. security clearance: Yes or No
Note, I have create PDF copies per year 1999 to 2015 and converted PDF of 2015 into Word thinking I could then extract all the specific information using a Word Macro but recording Macros have issues with copy & paste.
My first post,