Sending Emails to users with filenames

[yashpande]

Hi All,

My question is related to send emails to users. I have a data set user_details which has variable user_name and another dataset file_details which has list of big files (over 10gb )against those users. I need to send emails to all of them asking to delete unnecessary files.

Sample user_details table :

User_name

L01234

M09677

Sample file_details:

User_name File_name Size

L01234 c:\test1.txt 12

L01234 c:\test2.txt 11

M09677 d:\sample1.txt 34

M09677 d:\ sample2.txt 17

So I need to send emails to users L01234 and M09677.  Email should be something like

Hi L01234,

Please delete unnecessary files.

You may look at following files:

C:\test1.txt

C:\test2.txt

Similar mail should be sent to user M09677

Any ideas on how to accomplish this ?

[mnjtrana]

Hi,

You can use the below sample code to send emails to the users, first we set your input dataset, lets call it -' have', the code will create a script in temp loation named(email_snd), which will be called using %inc and email will be sent based on data provided in the have data-set.

filename email_snd temp;

data _NULL_;
set have; /*put you input dataset name here*/

length 
rec1 $50. rec2 $50. rec3 $30. rec4 $30. rec5 $30. rec6 $30. rec7 $30.;

rec1 = %nrstr("filename mymail email '#email_id#@site.com' subject='Delete Big Files';");
rec1 = tranwrd(rec1, '#email_id#', User_name);
rec2 = %nrstr("data _null_;");
rec3 = %nrstr("file mymail;");
rec4 = %nrstr("put 'Hi #usr_id#';");
rec4 = tranwrd(rec4, '#usr_id#',User_name);
rec5 = %nrstr("put 'Please delete unnecessary files.';");
rec6 = %nrstr("put 'You may look at following files:';");
rec7 = %nrstr("put '#file_name#' ;");
rec7= tranwrd(rec7, '#file_name#', File_name);

file email_snd;
put 
rec1 /
rec2 /
rec3 /
rec4 /
rec5 /
rec6 /
rec7;

run;

%inc email_snd;
run;