11-05-2013 08:19 AM
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 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
Please delete unnecessary files.
You may look at following files:
Similar mail should be sent to user M09677
Any ideas on how to accomplish this ?