RE: [sqr-users] Sending EMAIL from an SQR Program

["Jeff Blaisdell" <jblaisde@fastenal.com>]

When I have to send an email, I do it issueing a mailx Unix call.

Mailx syntax info can be found:
http://www.computerhope.com/unix/umailx.htm

Here's an example...

BEGIN-SELECT
email_address 
   let $emailaddress =ltrim( rtrim(&email_address, ' '), ' ')
   let $command = 'mailx -s "' || $emailsubject || '" ' || $emailaddress
|| ' < ' || $emailfilename
   show $command
   call system using $command #unix_status   
   if #unix_status <> 0
     show 'Error sending e-mail to: ' $emailaddress
   end-if 
FROM ps_fas_email_tbl
WHERE fas_module = 'AR' 
  AND fas_prg_name = 'FASAR789' 
  AND status = 'A'
END-SELECT

-----Original Message-----
From: Jenny Mckeon [mailto:MCKEON@shands.ufl.edu] 
Sent: Monday, September 25, 2006 12:12 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Sending EMAIL from an SQR Program

Is it possible to send an EMAIL with the "message" in the body of the
EMAIL, not in an attachment. The message will have variables.



Jenny Mackinnon
Shands Healthcare, Info. Svcs.
Application Systems Analyst
(352) 265-0680, ext. 8-5232
internet:mckeon@shands.ufl.edu



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users