topic Re: Sending email from SAS in SAS Programming

Sending email from SAS

TYT88 — Thu, 09 Jan 2020 08:18:56 GMT

I have written a program to send out email from SAS and it works fine.

My question is why does it only work on my PC? My colleague tried to run SAS program and it finished successfully with no error or warnings but the email was not received by intended recipient.

Re: Sending email from SAS

yabwon — Thu, 09 Jan 2020 08:31:27 GMT

Hi @TYT88 ,

Could you share some more details about the setup you have to send emails?

Maybe compare your and your colleague setups?

All the best

Bart

P.S. Did recipient checked the "spam" folder?

Re: Sending email from SAS

TYT88 — Thu, 09 Jan 2020 08:35:13 GMT

All the setup is in the SAS program and we didn't change anything

Re: Sending email from SAS

Kalind_Patel — Thu, 09 Jan 2020 08:38:41 GMT

Sending email from SAS requires Email Client tools to be installed and configured properly, for eg: Outlook,
SAS Uses email clients to send an email, there maybe possibility that SAS executed the mail command but an email client tool is not able to send it.
Generally when you run the send email command from SAS, you might get this kind of popup from your outlook application, you have to allow it to allow the SAS to send the email.

Re: Sending email from SAS

TYT88 — Thu, 09 Jan 2020 08:42:30 GMT

Outlook is installed and configured

And yes, we both click on Allow

Re: Sending email from SAS

Kalind_Patel — Thu, 09 Jan 2020 08:55:48 GMT

If you're getting this popup which means SAS finished it's job, now it's Outlook's responsibility to send it,
Are you able to see the unsent messages in Outbox or Sent Email folder in Outlook?

Re: Sending email from SAS

TYT88 — Thu, 09 Jan 2020 09:30:03 GMT

Not able to see the email in unsent messages in Outbox or Sent Email folder in Outlook

Re: Sending email from SAS

SASKiwi — Thu, 09 Jan 2020 22:19:07 GMT

If it doesn't show in the Sent Email folder then Outlook never sent it.

There is obviously something different about the SAS / email setup on the PC where it doesn't work.

Please post the program you are using.

Re: Sending email from SAS

TYT88 — Fri, 10 Jan 2020 01:57:42 GMT

Here is the program with modified email address to hide anonymity

FILENAME output EMAIL
FROM = ("test@mail.com")
SENDER = ("test@mail.com")
TO = (&TOEMAILS)
CC = (&CCEMAILS)
BCC = (&SIM_MEMBERS)
SUBJECT = ("test mail")
CONTENT_TYPE="text/html";
ODS HTML BODY=output options(pagebreak='no') style =MYSTYLE;

PROC ODSTEXT;
P "test mail";
P ' ';
P "xxxx";
P "(For Internal Use only)";
RUN;

PROC TABULATE DATA=table1 FORMAT=COMMA15.;
CLASS location sales;
classlev location/ S={foreground=BLACK BorderWidth=1 background=powderblue FONT_FACE='ARIAL' font_size=8pt VJUST=C width=1.75in};
classlev sales / S={foreground=BLACK BorderWidth=1 BorderrightWidth=7 background= LIGY FONT_FACE='ARIAL' font_size=8pt borderwidth=1 width=1.75in};
VAR &LMMM._Actual &MMM._RunRate Month_Target/ s=[foreground=BLACK BACKGROUND=WHITE BorderWidth=1 background=PAGY FONT_FACE='ARIAL' font_size=8pt FONT_WEIGHT=BOLD width=1in];
VAR Achievement / s=[foreground=BLACK BACKGROUND=WHITE BorderWidth= 1 BorderrightWidth=7 background=PAGY FONT_FACE='ARIAL' font_size=8pt FONT_WEIGHT=BOLD width=1in];
FORMAT location Hcode. sales Vcode.;
TABLE location ='',
sales=''*(&LMMM._Actual*{S=[FONT_FACE='ARIAL' BorderWidth= 1 FOREGROUND=BLACK font_size=8pt]}*SUM=''
&MMM._RunRate*{S=[FONT_FACE='ARIAL' BorderWidth= 1 FOREGROUND=BLACK font_size=8pt]}*SUM=''
Month_Target*{S=[FONT_FACE='ARIAL' BorderWidth= 1 FOREGROUND=BLACK font_size=8pt]}*SUM=''
Achievement*f=pctfmt9.*{S=[FONT_FACE='ARIAL' BorderWidth= 1 fontweight=bold BorderrightWidth=7 BACKGROUND= PCT. FOREGROUND=FONT. font_size=8pt]}*SUM='')
/ BOX={LABEL='XXX' S=[foreground=BLACK background= powderblue FONT_FACE='ARIAL' font_size=10pt font_style=italic borderwidth=1]};
RUN;

PROC ODSTEXT;
P "";
P "Kindly contact XXXX for any enquiries.";
RUN;

ODS _ALL_ CLOSE;
FILENAME output CLEAR;

Re: Sending email from SAS

TYT88 — Fri, 10 Jan 2020 03:10:02 GMT

I found out is because the MS outlook was not open

Once MS outlook is opened, all the emails sent out

However they are a bunch of HTML tags - what did I do wrong?

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta name="Generator" content="SAS Software Version 9.4, see www.sas.com">
<meta http-equiv="Content-type" content="text/html; charset=windows-1252">
<title>SAS Output</title>
<style type="text/css">
<!--
.activelink
{
color: #800080;
}
.aftercaption
{

Re: Sending email from SAS

Kalind_Patel — Fri, 10 Jan 2020 03:29:53 GMT

I missed one thing to check, Which emailsys option you're using?

Is it SMTP ot MAPI? You can check it by running this command:

proc options option=emailhost;run;

IF you're using SMTP option then mostly you'll not get any mails in your outbox or Sent email in Outlook,
Only MAPI method shows an sent emails in outlook,

You can refer this link for more details:
https://serverfault.com/questions/558034/smtp-sent-e-mail-not-copied-to-sent-folder

For troubleshoot, you can try with MAPI method instead of SMTP and at at last you can raise a track in SAS Technical Support to investigate further.