Try following

SET HEADINGS OFF
lcTempFile = < temp file name >
SELECT patient_id FROM mytable TO FILE (lcTempFile )
lcList = Filetostr(lcTempFile )
...

'Patient Id: ' + lcList 
...
ERASE (lcTempFile )

>I want to report via email patient id codes that are present in a table...here's what ihave so far but i'm nto sure how to add the patient ides from the table...one email can have 1 patient id or 10 patient id's but i only want to create one email that lists all patient ids that pertain to the center...

>
>oMailItem = oOutlook.CreateItem(0)
>WITH oMailItem
> .Body = 'Listed below are the results of your fax request: ' + CHR(13) + CHR(13) + ;
> 'HTC ID: ' + ALLT(FAXTRAX.Htc_Id) + CHR(13) + ;
> 'Patient Id: ' < here is where all the patient ids will go, carriage return after each id >
>
>example
>
>list below are the results of your request:
> htc id: 356
> patient id(s): 356-4444
> 356-3943
> etc etc etc...
>
>hope someone can help!