DO WHILE NOT EOF() One_large_string=One_large_string+firstemail.FirstEmail ....Messagebox will not display the entire content of One_large_string if it is large enough.
>LOCAL strBCC
>
>STORE SQLSTRINGCONNECT(;
>'DBQ=H:\Access\email.mdb;'+;
>'DefaultDir=H:\Access;'+;
>'Driver={Microsoft Access Driver (*.mdb)}');
>TO gnConnHandle
>= sqlexec(gnConnHandle,"SELECT FirstEmail from tblemail WHERE SendFirst = True","firstemail")
>
>SELECT firstemail
>GO TOP
>
>DO WHILE NOT EOF
>Messagebox(firstemail.FirstEmail)
>NEXT
>ENDDO
>