topic Re: How to send SAS email to multiple participants in SAS Programming

How to send SAS email to multiple participants

Azeem112 — Wed, 04 Jul 2018 11:23:22 GMT

I've a macro variable as

%let emails = "A@sas.com B@sas.com";

options emailsys=smtp emailhost=domain.com  emailport=25; 
			filename outbox EMAIL;

			data _null_;
				
				file outbox
				TO=(&emails)
				FROM =('sas_noreply@domain.com') 
				type="text/html"
				subject=("SAS ALERT:");

				put '<html>';
				put '<body>';
				put '<div>';
				put '<p>Message Body</p>
				put '</div>';
				put '</body>';
				put '</html>';
			run;

and I'm sending it using the upper code

I receive the error that email is bad.

I've tried

"'a@sas.com' 'b@sas.com'"

"a@sas.om b@sas.com"

("a@sas.om b@sas.com")

Kindly provide support.

Please note, I've only a macro variable containing list of comma separated emails.

Comma separated mails are working in "CC" but in "TO" system throws error

ERROR: Email: 501 Syntax error, parameters in command "RCPT
       TO:<a@sas.com,b@sas.com>" unrecognized or missing
WARNING: Bad e-mail address: (a@sas.com,b@sas.com)
WARNING: No email addresses specified.

Re: How to send SAS email to multiple participants

Kurt_Bremser — Wed, 04 Jul 2018 11:36:11 GMT

Just a tiny change in your %let:

%let emails = "A@sas.com" "B@sas.com";

and

filename outbox email
  to=(&emails)
  from =('sas_noreply@domain.com') 
  type="text/html"
  subject=("SAS ALERT:")
;

data _null_;
file outbox;

Re: How to send SAS email to multiple participants

s_lassen — Wed, 04 Jul 2018 11:43:26 GMT

I think your macro variable should contain a list of quoted mail adresses, e.g.

%let emails="A@sas.com" "B@sas.com";
TO=(&emails)

Re: How to send SAS email to multiple participants

Azeem112 — Wed, 04 Jul 2018 11:55:20 GMT

Thanks a lot Everyone for Quick response. It's working.