topic Re: Email Address with single quote in SAS Programming

Email Address with single quote

claridad123 — Tue, 26 Oct 2021 11:33:40 GMT

I would like to send the email to multiple user, while one email address has a single quote in it: M'ma.E.Smith@gmail.com. Put double quote like M''am.E.Smith@gmail.com does not work.
Much appreciated the help!

%let email_out='Adam.X.Smith@gmail.com'
		'Barbara.C.Smith@gmail.com' 
	        'Cyndi.D.Smith@gmail.com'
	      'M''ma.E.Smith@gmail.com');
		
filename mymail email 
         	subject="Automated Report: Test"
			TYPE='text/html';

			data _null_;
				file mymail
				from=('Test@gmail.com')
			 	to=( &email_out);
			   put 'Test Program';
			 run;

Re: Email Address with single quote

PaigeMiller — Tue, 26 Oct 2021 12:12:25 GMT

... does not work

You have a parenthesis at the end of the value of macro variable &email_out, which won't work. What happens after you remove the parenthesis?

When code doesn't work, show us the LOG, all of the LOG for this portion of code, every single line in the LOG for this portion of code. Do not chop parts of out the LOG for this portion of code.

Re: Email Address with single quote

claridad123 — Tue, 26 Oct 2021 13:22:18 GMT

Using %quote("M'ma.E.Smith@gmail.com") and problem solved