Hi there, this is my first time posting a question online I usually stick to lurking and finding similar queries to my own but alas I am having a world of difficulty setting the email configurations up in SAS EG so that I can get the program up and Running. I thank you all for all the help you provide the community I've found a ton of info already thanks to you all. My goal is to have an automated program that is scheduled for a user, upon being started it will conclude a set of predetermined tasks and email the user that made the request the results of the task. Now I have everything ready but the last piece of the puzzle is the email part. I cannot use the send to -> Email Recipient as a Step in Project because as far as I can tell I can't give it a dynamic variable for it to use as the email recipient. proc sql noprint;
select c_email
into :email
from USER_INFO
;
quit; I create the email variable with the above code and then wish to use it for sending the the email to the recipient &email. Now my companies email is a outlook base email from the office 365 schema. So I though using the MAPI solution would be enough for me and it works fine when I run the task straight from SAS EG. But when the program is invoked as a scheduled task from a user request it does not run the email program. But it doesn't specify the error either. It just has a cross mark on the program. options
emailsys="MAPI"
EMAILID="xxx.yyy@company.com"
EMAILAUTHPROTOCOL=none
;
FILENAME Mailbox EMAIL 'xxx.yyy@company.com'
Subject='STARTUP';
DATA _NULL_;
FILE Mailbox;
PUT "Hello";
PUT "This is a test message from the DATA step";
RUN; So I've tested a few solutions SMTP connection with my GMAIL account for testing, MAPI with the companies Outlook client and using the E-mail Recipient step. The gmail connection through SMTP works fine run directly from the task and invoked as a scheduled request from a user: options
emailsys="smtp"
EMAILHOST="smtp.gmail.com"
EMAILPORT=25
EMAILID="xxx.yyy@gmail.com"
EMAILAUTHPROTOCOL=plain
EMAILPW="{SAS002}xxxx"
;
options emailhost=
(
"smtp.gmail.com"
/* alternate: port=487 SSL */
port=587 STARTTLS
auth=plain
/* your Gmail address */
id="xxx.yyy@gmail.com"
/* optional: encode PW with PROC PWENCODE */
pw="{SAS002}xxxx"
)
;
filename myemail EMAIL
to=("&mail")
subject="abc - Request from &user"
attach = 'C:\Desktop\abc.csv';
data _null_;
file myemail;
put "Dear User,";
put "The request information is annexed in the current email";
put "Best Regards,";
put "xxx";
run;
filename myemail clear; Now this is where I am stuck right now because from what I can the the E-mail Recipient also use a SMTP connection but I cannot replicate it by script. It also uses Windows authentication. So now how do I replicate the connection that this module is using by script? I tried the following, but I get an ERROR: Email: The connection was refused. The code I tried was as follow and I tried to mimic the gmail script: options
emailsys="smtp"
EMAILHOST="mail.company.com"
EMAILPORT=25
EMAILID="xxx.yyy@company.com"
EMAILAUTHPROTOCOL=plain
EMAILPW="{SAS002}xxxx"
;
options emailhost=
(
"mail.company.com"
/* alternate: port=487 SSL */
port=587 STARTTLS
auth=plain
id="xxx.yyy@company.com"
/* optional: encode PW with PROC PWENCODE */
pw="{SAS002}xxxx"
)
;
FILENAME Mailbox EMAIL 'xxx.yyy@company.com'
Subject='STARTUP';
DATA _NULL_;
FILE Mailbox;
PUT "Hello";
PUT "This is a test message from the DATA step";
RUN; with auth = none I get ERROR: Email: 530 5.7.1 Client was not authenticated. And I know that this probably means that I cannot use an SSL to TLS request. But I just can't understand how to use the Windows Integrated authentication for the SMTP request the same that the E-mail Recipient does ... Any help on understanding why using MAPI isn't working as a scheduled taks or why I can use my account with a SMTP request from the E-MAIL Recipient task but can't replicate it by code on a data step would be apreciated. Some of my reading material can be found here: https://support.sas.com/resources/papers/proceedings13/023-2013.pdf http://support.sas.com/resources/papers/proceedings13/340-2013.pdf https://www.lexjansen.com/pharmasug/2007/tt/TT09.pdf https://blogs.sas.com/content/sasdummy/2013/07/31/gmail-from-sas-program/ http://support.sas.com/resources/papers/proceedings10/060-2010.pdf Best Regards, WIzarDE
... View more