View Single Post
  #4   Report Post  
Posted to microsoft.public.word.pagelayout
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Extracting data from forms

It shouldn't be too hard to produce the results of this method in a single
file for a batch of documents ... I feel another web page coming on

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



CyberTaz wrote:
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