Getting data out of a form

[UserX]

I need to transfer/export data that has been entered into
a form over into Excel or Access. The form was designed
elsewhere and all forms are already filled in. thanks!

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi UserX,

What sort of forms are they? If they used formfields, you can access the
data by referencing the .Result property of the formfield.

If you save all of the forms to a separate folder, you can set up a batch
process to open each form in turn, and access the data in it, and write the
information to a database.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP