View Single Post
  #3   Report Post  
Posted to microsoft.public.word.pagelayout
CyberTaz CyberTaz is offline
external usenet poster
 
Posts: 1,348
Default Extracting data from forms

Graham's reply provides an excellent method - especially if this is
something you need to do on a repetitive basis. Just on the off chance that
it may be a "one time thing" here's another option that might be useful but
less entailed since you don't have to deal with code.

In Word 2003 or prior Tools Options - Save provides a setting to Save Data
Only for Forms. In 2007 it's in Office Button Advanced Preserve Fidelity
when Sharing this Document - Save Form Data as Delimited Text File.

The resultant save can then be imported into Excel or Access.

Regards |:)
Bob Jones
[MVP] Office:Mac



On 6/7/08 5:58 PM, in article , "Mark
Lewis" wrote:

Is it possible to extract data from user entered fields into Access or
Excel?

Thanks

Mark