topic SAS Email through EG, Connection Refused in SAS Programming

SAS Email through EG, Connection Refused

Lost_Gary — Fri, 29 Jul 2022 19:49:15 GMT

I am using SAS EG8.3 and trying to send an email via SAS for the first time at this company. My code is as follows:


options emailsys=SMTP
emailport=25
emailid="myemail@mycompany.com";
options emailhost=
(
   "smtp.office365.com" 
port=25 STARTTLS
Auth=login
id="myID"
pw="mypw");
filename fileref email ("myemail@mycompany")
From="myemail@mycompany"
Subject="Test message"
type="text/html";
ods html body= fileref style=printer
text="Testing";
ods html close;
filename fileref clear;

The email log simply states:

ERROR: Email: The connection was refused.

I think I only just need to tweak a setting because if i switch this to emailsys=MAPI

the email will send but it prompts this message

Obviously I would like to email without the prompt. Any thoughts are appreciated.

Re: SAS Email through EG, Connection Refused

SASKiwi — Fri, 29 Jul 2022 23:20:32 GMT

What happens if you click "Allow"?

Talk to your IT folks about Outlook security settings to see if there is a way to avoid this popup.

Re: SAS Email through EG, Connection Refused

Lost_Gary — Sat, 30 Jul 2022 11:37:43 GMT

If I click ‘Allow’ an e-mail is sent (although it appears to be xml language and not my intended content).

Re: SAS Email through EG, Connection Refused

SASKiwi — Sat, 30 Jul 2022 23:33:50 GMT

The fact that it successfully sends your email indicates that your SAS program is using the right email settings. Most likely Outlook security settings need tweaking to stop the prompt which your IT security / email experts should be able to help with. Talking to your SAS administrator would be a good idea too.

Re: SAS Email through EG, Connection Refused

Lost_Gary — Mon, 01 Aug 2022 11:40:46 GMT

what and where is that Outlook setting? If I can tell IT what I need changed, I have a much higher chance of getting it done.

Re: SAS Email through EG, Connection Refused

ChrisHemedinger — Mon, 01 Aug 2022 12:15:19 GMT

Sending using MAPI will trigger your local Outlook client to send the message. The prompt you see is a security measure to prevent "rogue" processes from sending emails without your knowledge. (Imagine the spam bots that could exploit "quiet" automation of emails on your local PC...)

SMTP is the best practice for email automation. However, using Microsoft 365 and SMTP is tricky and might not be possible. See for general guidance about sending emails from SAS, including using cloud-based email.

These articles describe the requirements for getting SMTP working for Microsoft 365 from 3rd party apps, or alternatively using an API for the task: