>Hi,
>I want to convert a dbf record to a text file,
>and I want the result as follow:-
>
>Souce DBF file, only 1 field in a table.
>
>Email
>abc@hotmail.com
>bbb@hotmail.com
>ccc@hotmail.com
>eee@hotmail.com
>fff@hotmail.com
>
>Result Text File
>
>abc@hotmail.com,bbb@hotmail.com,ccc@hotmail.com,eee@hotmail.com,fff@hotmail.com
>
>If the source file have 1000 or more records, then the text file
>cannot hold all the record in one line. it will truncate the record to
>next line, so what is the max. lenght of the text file can handle under foxpro 9 ?
>
>Please advise.
>Derek Yim

Are you creating a list of email recipients for Outlook? If so, Outlook has a limit to how long the string can be, so you have to send more emails in stead.