LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2001, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 26 Mar 2001 20:37:50 +0000
Reply-To:   mauro.morandin@MATRIX-ONLINE.IT
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   mauro.morandin@MATRIX-ONLINE.IT
Organization:   Mailgate.ORG Server - http://www.Mailgate.ORG
Subject:   Re: Email from SAS v612 via Lotus Notes
Content-Type:   text/plain; charset=us-ascii

Hi Victor,

you have to tell SAS to send the email through Lotus Notes and not through vim or other mail transport agents. I have done this 3 years ago and don't remember the details, so I have looked into the SAS sample library and found an example you could use. If all the paths on your WinNT are set correctly this should work.

It uses the notesdb access engine! Hope it helps.

Ciao. Mauro.

/****************************************************************/ /* S A S S A M P L E L I B R A R Y */ /* */ /* NAME: NOTES1 */ /* TITLE: Lotus Notes Example 1 : Populating a Notes +*/ /* Database via a Form */ /* PRODUCT: SAS */ /* SYSTEM: OS/2, Windows */ /* KEYS: LOTUS NOTES */ /* PROCS: */ /* DATA: */ /* */ /* REF: */ /* MISC: */ /* DESC: Demonstrates how to populate a Lotus Notes document */ /* database from within a SAS DATA step via a Notes */ /* database form. */ /* Before submitting this sample code, ensure that */ /* Lotus Notes is installed on your machine (including */ /* the example Notes database "Jim Hansen's Mail"). */ /****************************************************************/

/* Define a fileref using the Lotus Notes access method. This */ /* will enable us to send directives to the fileref instructing */ /* the NOTESDB engine what tasks we want it to perform. */

FILENAME ndbdata NOTESDB;

/* Using a DATA step, we will send information for a new mail */ /* message to be added to the Lotus Notes example database "Jim */ /* Hansen's Mail". The directives used in the PUT statements */ /* indicate the physical filename of the Notes database being */ /* updated (!NSF_DB!), the name of the database form to be used */ /* (!NSF_FORM!) and the name of the field being updated, */ /* followed by the value to update it with (!NSF_FIELD!). */

DATA _NULL_; FILE ndbdata; PUT '!NSF_DB!examples\jhansen.nsf'; PUT '!NSF_FORM!Memo'; PUT '!NSF_FIELD!SendTo!Jim Hansen @ lynxdomain'; PUT '!NSF_FIELD!Subject!A Message from The SAS System'; PUT '!NSF_FIELD!DeliveryPriority!N'; PUT '!NSF_FIELD!DeliveryReport!N'; PUT '!NSF_FIELD!ReturnReceipt!0'; PUT '!NSF_FIELD!Body!This is a test message sent to you from ' 'the SAS System.'; RUN;

/****************************************************************/

> [Previous] [Next] [Reply] [Index] [Home] [Find] > > * Newsgroups: comp.soft-sys.sas > * From: hello@idontbelieveit.com (Victor Meldrew) > * Subject: Email from SAS v612 via Lotus Notes > * Date: Thu, 22 Mar 2001 17:29:45 GMT > * Organization: Virgin Net Usenet Service > > ------------------------------------------------------------------------ > > Hi > > I'm trying to get SAS to interface with Notes to send mail messages > out when jobs fail. I've got the job fail bit done, but I can't get > SAS to talk to Notes via datastep. If I try using "File, Send...", > then it's fine, the dialog comes up as normal, and I can send messages > anywhere I like. > > System details are: > > Windows NT4 Workstation (although will be running on server later), > both SP4 or above. > Notes Client version 4.5.2 (Intl) 26 June 1997 (maybe a newer version > on the server once it's installed) > SAS v6.12 TS045(W/S), TS060 (Server). > > My code is: > > filename notify email 'nul' attach="c:\sas\config.sas" ; > > data _null_ ; > file notify ; > name = 'Ben Kentzer/UK/AMP@AMP' ; > put '!EM_TO!' name; > put '!EM_SUBJECT! PROD10: Failed Jobs in Refresh' ; > put name ','; > put 'The attached file gives details of any failed jobs.' ; > put '' ; > put 'Please check the log file area for further details.' ; > put '!EM_SEND!'; /* This bit is so that I can send the > same > message to a list of people... */ > put '!EM_NEWMSG!'; /* NAME above is for testing. It will be > stored in a > dataset */ > put '!EM_ABORT!'; > run ; > > The message I get in the log is: > > ERROR: E-mail initialization failure. Verify that E-mail is installed > FATAL: Unrecoverable I/O error detected in the execution of the data > step > program. > Aborted during the EXECUTION phase. > > I've set -emailsys=vim on the command line. The vim dll (vim32.dll) is > in the path. > > Anyone got any ideas? A guy here managed to get it working, but then > left before telling anybody what he did! > > Cheers > > Ben > > ------------------------------------------------------------------------ > [Previous] [Next] [Reply] [Index] [Home] [Find] > Mailgate.ORG is maintained online by Dario Centofanti

-- matrix srl linux solution provider via postioma di salvarosa 25b tel +39-0423-724620 31033 castelfranco veneto (tv) fax +39-0423-770798 http://www.matrix-online.it info@matrix-online.it

-- Posted from flat-pool18-mdm091.aruba.it [62.149.157.93] via Mailgate.ORG Server - http://www.Mailgate.ORG


Back to: Top of message | Previous page | Main SAS-L page