Export bookmark to delimited file

  • Thread starter Thread starter Russell Codd
  • Start date Start date
R

Russell Codd

I am using Microsoft Word 2000.

I have a form set as a template that has several fields in, which the user
can select and change. As this is done, it updates a reference field at
the bottom of the document. This means the data the user enters can be
collated together for export. I have separated each of these reference
fields with a % sign, and called all the fields together as another
bookmark (alldata).

I know want to be able to export the alldata bookmark as a delimited file
to either a plain text file, or ideally, straight into Excel, where I can
use this to create mail merge forms.

Any help?
 
Is this an "Online Form", with form fields? If so, could you just use Word
Tools|Options|Save|Save data only for forms to export the content of the
form fields, then import the data into Excel and create the concatenated
bookmark there?

I only mention that because you may not be aware of the "save data only"
option. However, I think you may be better off using VBA automation to open
the Excel spreadsheet directly, get the bookmark value, work out where to
put it in Excel (you would need to think about what you want there) and
close the sheet.
 
Back
Top