To close file issue SET TEXTMERGE TO. See code below

set textmerge on to filename.txt 
select table
SCAN
  \<< fieldname1 >>, << fieldname2 >> 
ENDSCAN
set textmerge off
set textmerge TO

I added extra speces to prevent UT parser from interpreting << and >>.

>Hello guys,
>
>Is it possible to do the following
>
>inMergevar = "set textmerge on to filename.txt additive "
>inMergevar = inMergevar + " << fieldname1 >>, << fieldname2 >> "
>inMergevar = inMergevar + " set textmerge off"

>sele table
> do while not eof()
>  &inMergevar  <-- can I reference the command in here
>  skip
> enddo

>the file gets created not data on it, and besides it gets locked by the
>foxpro program, I had to exit VFP completely to open the file
>
>tx
>
>mark oliva