Ask the Expert

Export Notes text fields to a text file

am trying to export certain text fields (field1, field2, field3 etc) in a Notes documentout to a text file. Each field value needs to be in the first column of the file and on its own row for reading by an AutoCad R14 lisp program. Example file structure below:

 Field1 Field2 Field3


I would suggest creating a LotusScript agent that will do the following, in order.

1) Build a query (to select docs to output)
2) Build a doc collection from the query
3) If doc collection > 0 then open a sequential file
4) Iterate through the docs, using Print # statement
5) Close the file


This was first published in November 2001