Thanks Sergey

the only issue is that the fields that I will be
merging varies depending on a code, sometimes
can be 3 fields or 4 or 2
that is why I initially though of a vaiable
that will hold them

tx

mark oliva

>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
></>
>

>>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