topic Re: Automatic email to an address with a "-" in it in SAS Programming

Automatic email to an address with a "-" in it

Sheu — Wed, 01 Apr 2020 15:49:18 GMT

I'm running into an issue where one of my recipients has a "-" in their email address when I'm setting it up in %LET EMAIL_TOLIST=

"ERROR 23-2: Invalid option name" is the error message that pops up.

Is there a way to work around this?

Re: Automatic email to an address with a "-" in it

Kurt_Bremser — Wed, 01 Apr 2020 16:00:06 GMT

Please post the whole log from the %let up to the ERROR. Use the </> button for posting the log.

Re: Automatic email to an address with a "-" in it

Sheu — Wed, 01 Apr 2020 17:53:13 GMT

49 %LET EMAIL_TOLIST= 'abc-abc@*****.com';
50
2 The SAS System 13:37 Wednesday, April 1, 2020

51
52
53 options emailsys=smtp emailhost=intmail.*****.net emailport=25;
54 filename mymail email &EMAIL_TOLIST
55
56 type='text/html'
NOTE: Line generated by the macro variable "EMAIL_TOLIST".
56 'abc-abc@*****.com'
_______________________________
23
ERROR 23-2: Invalid option name 'abc-abc@*****.com'.

57 subject='Test';
ERROR: Error in the FILENAME statement.

Re: Automatic email to an address with a "-" in it

LeonidBatkhan — Wed, 01 Apr 2020 18:16:56 GMT

I don't think "-" is a problem. What are your asterisks ***** in the emailhost and why it's not quoted?

Can you please place your code to show what exactly you run?

Re: Automatic email to an address with a "-" in it

Sheu — Wed, 01 Apr 2020 18:20:02 GMT

The code works fine if I use a different email address though.

I'm just censoring out the email host name in case it's sensitive.

Re: Automatic email to an address with a "-" in it

LeonidBatkhan — Wed, 01 Apr 2020 18:32:23 GMT

Try using to=(&EMAIL_TOLIST) as in

filename mymail email to=(&EMAIL_TOLIST) type='text/html' subject='Test';

You can still place your code replacing partial email address and real server names with valid characters e.g. XXXXX, not ***** which as not valid for server and email names.

Re: Automatic email to an address with a "-" in it

Sheu — Wed, 01 Apr 2020 18:37:45 GMT

Thank you for the help!