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!
Thanks in Advance.
J. Turner