Converting Word Forms en masse to txt/csv format?

[GhostNWN]

Hello,

I have made a questionnaire in Word and have read the MS tutorial on "Save
form data for use in a database or spreadsheet" to perfect the output of the
resulting txt/csv file.

However, since I'll be sending it to about a hundred people, it would take a
long while to open a document, save, etc. Is it possible to automate the
saving into the txt format given that its already a form?

Also, is it possible to make it save all the data into 1 big txt/csv files
rather than make 1 for each response, but ensuring that when I import it into
excel, it will not put it all into 1 line but 1 line for each response?

Thanks for any help you can offer

 

[Graham Mayor]

You have not said which 'tutorial' you used, but you may have more success
with http://gregmaxey.mvps.org/Extract_Form_Data.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[GhostNWN]

Thanks for your reply Graham,

I read the basic office help file and the linked tutorial by greg as well. I
don't quite know how to modify that bit of code to import into excel rather
than access though. Would you be able to help please?

Thank you

 

[Graham Mayor]

Excel should be able to open the Access table, however, there's an
alternative approach on my web site to create a csv tile
http://www.gmayor.com/ExtractDataFromForms.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[GhostNWN]

Thank you Graham, that is exactly what I was looking for. You're a star

 

[Graham Mayor]

You are welcome

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>