I am creating an automatic email message to send out to users. In the body of the email I will populate the results of a query. The problem I have is that the query could result in say 50 records. Once I have my results in a cursor I then use the following proc to produce the body of the email:

set textmerge to memvar m.lcBodyquery noshow
set textmerge on
\
\
\<<PADR(LTRIM('ArticleNo'),15,' ')>>
\\<<PADR(LTRIM('Quality'),20,' ')>>
\\<<PADR(LTRIM('Supplier'),20,' ')>>
\\<<PADR(LTRIM('Width'),15,' ')>>
\\<<PADR(LTRIM('Price'),15,' ')>>
\\<<PADR(LTRIM('Country'),20,' ')>>
\---------------------------------------------------------------------------------------------
IF !EMPTY(crsmatch.artikey)
scan
\<<padr(LTRIM(crsmatch.articleno),15,' ')>>
\\<<padr(LTRIM(crsmatch.descrip1),20,' ')>>
\\<<padr(LTRIM(crsmatch.seamslippa),20,' ')>>
\\<<padr(LTRIM(crsmatch.width),15,' ')>>
\\<<padr(LTRIM(STR(crsmatch.atpricec,5,2)),15,' ')>>
\\<<padr(LTRIM(crsmatch.arepcmt1),20,' ')>>
ENDSCAN
\---------------------------------------------------------------------------------------------
ELSE
\
\No Matches found!
\
\---------------------------------------------------------------------------------------------
ENDIF
\
\Please indicate as to whether you wish to transfer this Hanger against an Article from the list
\by supplying the Article No in the box below or please enter the details of the fabric and let the
\system create the Article and attach the hanger for you. 
\
\Best Wishes 
\VWM Workflow Manager
set textmerge to
set textmerge off

Problem I have is that there seems to be a limitation of how much information I can store to m.lcBodyQuery. Can anybody suggest how I can do this no matter how big the query is?