Hi Sriram,
You'd need to use Word automation to extract the data. For example, save all
the attachments into the same folder. Then use a macro in Word to open each in
turn, go through the form fields and write the data to... an Excel table? An
Access database?
> I set up a Word form with a table and fill-in fields, protected for forms
> and saved it as a template. I emailed the template document to respondents
> expecting them to fill out the new Word document generated from the template
> and send it back to me... I though it was a good idea at the time.
>
> Now I have several responses with the filled out Word documents as
> attachments. Is there any way to get the form response data into a table
> all at once?
>
> The only way I can get at the data so far is to
> - Save each attachment to a folder from Outlook
> - Open the saved files
> - Set to save only form data for each file from Tools | Options
> - Save each file in text format
> - Combine the contents of the bunch of text files using the copy command
> from a command window
>
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
Similar Threads
