You can use variable or you can use DO CASE inside of SCAN.
>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
--sb--