sending emails with attachment from sas

[tparvaiz]

Hi,

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

Thanks

[Jagadishkatam · Accepted solution]

I believe the below article will be helpful for your requirement

http://www2.sas.com/proceedings/forum2008/038-2008.pdf

[tparvaiz]

Hi,

I am using code that looks like this

%let label = &date.

data _null_;
file cmds;
put "[save.as(%bquote("X:\Weekly\File &label..xlsx"))]";
put '[CLOSE()]';
run;

FILENAME Mailbox EMAIL 'temp@microsoft.com'
Subject='Test Mail message' ATTACH='X:\Weekly\File May 2017.xls';
DATA _NULL_;
FILE Mailbox;
PUT "Hello";
PUT "Plesae find Report as an attachment";
PUT "Thank you";
RUN;

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

ATTACH='X:\Weekly\File &label..xlsx';

[Jagadishkatam]

when you mention macro variables you have to use double quotes

You can try below

ATTACH="X:\Weekly\File &label..xls";

[tparvaiz]

Thanks

[SASKiwi]

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.

[Kurt_Bremser]

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?