topic Re: SMTP Sendgrid connection in SAS Programming

SMTP Sendgrid connection

Erockanderson — Fri, 13 Sep 2024 22:21:37 GMT

Hi. I'm trying to configure the email options to send email through sendgrid. It uses and API key. Below are the options I have set, but I can only get SAS to respond with "ERROR: Login Failure" and "ERROR: Email server did not respond"

What do I need to tweak in the settings to get it to connect?

options
emailsys=SMTP
emailhost=("smtp.sendgrid.net" STARTTLS)
emailport=25
emailid="YXBpa2V5 <notices@bcservicescommercialcollections.com>"
EMAILAUTHPROTOCOL=login
EMAILPW='U0cuOHl0RlZVRHJRWXU2QTVSeUczelppUS4xFaRlZ2dXBpd3dZZG5J';

Re: SMTP Sendgrid connection

ChrisNZ — Thu, 19 Sep 2024 18:21:33 GMT

1. For your own sake, remove the credentials in your post

2. Did you see http://support.sas.com/kb/53/215.html ?

Re: SMTP Sendgrid connection

Erockanderson — Thu, 19 Sep 2024 18:45:55 GMT

Thanks for the reply. The password is not correct in my post.
I did see that document. I still cannot get it to work with the emailhost option.

Re: SMTP Sendgrid connection

ChrisNZ — Thu, 19 Sep 2024 18:54:34 GMT

I did see that document. I still cannot get it to work with the emailhost option.

You haven't used to recommended syntax:

For SAS^® 9.4, it is recommended that you use the EMAILHOST option to accomplish this step:

-emailhost ("smtp.gmail.com" STARTTLS id=gmail-login-ID pw=gmail-password auth=LOGIN port=587);