05-18-2017 07:15 PM
we use ms outlook 2016 and can you please advise how to send an email to multiple recepients A) with an attachment file and B) short header and body of the email.
my attachment is saved on the C drive
05-19-2017 09:13 PM
I am using code that looks like this
%let label = &date.
put "[save.as(%bquote("X:\Weekly\File &label..xlsx"))]";
FILENAME Mailbox EMAIL 'email@example.com'
Subject='Test Mail message' ATTACH='X:\Weekly\File May 2017.xls';
PUT "Plesae find Report as an attachment";
PUT "Thank you";
Question: as you can see, when I save my excel file it's using a variable/date as part of the file name but when I am referencing the attachment it's taking constant file name
how can I customize it to use variable file name when sending an email attachment, something like this
05-18-2017 07:39 PM
Does SAS run on your PC? If so you will be able to pick up local drive attachments. You also need access to an email gateway - an SMTP one in your case.
If you are using SAS on a server it would need to be configured to use an SMTP gateway and your attachments would have to be accessible from your server.
05-19-2017 03:45 AM
And how are you using SAS?
- Locally with native Display Manager?
- Locally, but through Enterprise Guide?
- Remotely on a server? If yes, please specify:
- the server's operating system
- SAS Studio or Enterprise Guide?
Need further help from the community? Please ask a new question.