topic Re: sending emails with attachment from sas in SAS Programming

sending emails with attachment from sas

tparvaiz — Thu, 18 May 2017 23:15:16 GMT

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

Re: sending emails with attachment from sas

Jagadishkatam — Thu, 18 May 2017 23:20:49 GMT

I believe the below article will be helpful for your requirement

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

Re: sending emails with attachment from sas

SASKiwi — Thu, 18 May 2017 23:39:03 GMT

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.

Re: sending emails with attachment from sas

Kurt_Bremser — Fri, 19 May 2017 07:45:07 GMT

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?

Re: sending emails with attachment from sas

tparvaiz — Sat, 20 May 2017 01:13:37 GMT

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';

Re: sending emails with attachment from sas

Jagadishkatam — Sat, 20 May 2017 02:22:05 GMT

when you mention macro variables you have to use double quotes

You can try below

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

Re: sending emails with attachment from sas

tparvaiz — Tue, 23 May 2017 21:57:11 GMT

Thanks