Export specific data from Microsoft word form to excel spreadsheet

Question

Hello I have made a WHS compliance check list form in Microsoft word. I write the name of the staff member at the top of the form with the date then a bunch of tick boxes to ensure they are compliant. I save-as each document under the staff members name in a folder. I just want to copy the name of the staff member the assessment and date it was completed into an excel spreadsheet to keep a record that I captured everyone for the year. Is it possible to automate this or do I have to do it manually one form at a time?

Answer 1

Here are two links to get you started:

• Extract Data From Protected Forms and Content Controls by Word MVP Graham Mayor and
• Extract Form Data by Greg Maxey