Solved: How to send SAS email to multiple participants

Azeem112 · Posted 07-04-2018 07:23 AM

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.

Kurt_Bremser · Posted 07-04-2018 07:36 AM

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;

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

View solution in original post

Kurt_Bremser · Posted 07-04-2018 07:36 AM

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;

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

s_lassen · Posted 07-04-2018 07:43 AM

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)

Azeem112 · Posted 07-04-2018 07:55 AM

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

How to send SAS email to multiple participants

Re: How to send SAS email to multiple participants

Re: How to send SAS email to multiple participants

Re: How to send SAS email to multiple participants

Re: How to send SAS email to multiple participants

How to send SAS email to multiple participants

Re: How to send SAS email to multiple participants

Re: How to send SAS email to multiple participants

Re: How to send SAS email to multiple participants

Re: How to send SAS email to multiple participants

2025 SAS Hackathon: There is still time!

SAS Training: Just a Click Away