Hello,
I was able to get the macro to work by hard coding an email in--it's the dynamic variable looking for values that keeps coming through missing; I have two other keyword variables that do work, so I suspect it's something with the email structure itself, though I'm not sure if it's in the macro code or if it's how I save the email (as text, in an excel; please let me know if this is the problem).
here is the log from the latest attempt, I did change emails and text for privacy:
1 + filename LIST Email; to=(".") from=("test@test.com") sender=(" Team") subject="Alert " type='text/html' attach=
--
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
2 +("\\...Report.pdf");
2 + data _null_; file LIST; put '<html><head>'; put '<style type="text/css"
3 + MEDIA=screen><!--'; put 'body { font-family: Calibri; font-size: 12pt; }'; put '.Message1 { color: Black; font-size: 11pt; font-weight: bold; }'; put '.Message2 { color: Black; font-size: 13pt; font-weight: italic; }'; put
4 + '--></style></head><body>'; put "Hello Sarah Smith at 555, <br />"; put "<br />"; put "<i> text"; put "text
5 + text"; put "text"; put "text
6 + text"; put "text"; put "text </i>"; put "</body></html>"; run;
NOTE: The file LIST is:
E-Mail Access Device
ERROR: No TO= address specified for email.
NOTE: 51 records were written to the file LIST.
The minimum record length was 6.
The maximum record length was 109.
NOTE: DATA statement used (Total process time):
real time 0.53 seconds
cpu time 0.46 seconds
