how to customize the send mails personalization for each person, code is below , please anyone help on this .Where
-where we make changes on my code
-Customize for each person send message
EMP_ID
EMP_NAME
GENDER
BIRTHDAY
COMPANY
DESIGN
LOC
MAIL_ID
100
VENKATA
MALE
24/11/22
SAMA
DIRECTOR
PUNE
ravindranadh2125@gmail.com
101
MURALI
MALE
24/11/22
SAMA
DEVELOPER
PUNE
ravindranadh2125@gmail.com
102
PRABHAKAR
MALE
24/11/22
SAMA
DOMAIN
BANG
ravindranadh2125@gmail.com
103
PRASANNA
FEMALE
24/11/22
INFOTECH
PROGRAMMER
HYD
ravindranadh2125@gmail.com
104
RAMYA
FEMALE
26/11/22
GOOGLE
DEVELOPER
KOCHI
ravindranadh2125@gmail.com
105
MOUNIKA
FEMALE
23/11/22
MICROSOFT
PROGRAMMER
CHENNAI
ravindranadh2125@gmail.com
106
KIRAN
MALE
26/11/22
ACCENTURE
ANALYST
BANG
ravindranadh2125@gmail.com
107
NIKIL
MALE
25/11/22
WIPRO
DEVELOPER
MUMBAI
ravindranadh2125@gmail.com
108
MANOHAR
MALE
24/11/22
CYIENT
PROGRAMMER
HYD
ravindranadh2125@gmail.com
109
RAVINDRA
MALE
26/11/22
INFOSIS
ANALYST
PUNE
ravindranadh2125@gmail.com
110
PAVAN
MALE
25/11/22
SAMA
PROGRAMMER
CHENNAI
ravindranadh2125@gmail.com
111
RAMANI
FEMALE
24/11/22
ELI LILLY
DEVELOPER
KOCHI
ravindranadh2125@gmail.com
options unbuflog; proc import datafile="/home/u61914035/import files/birthdayXL.xlsx" dbms=xlsx out=ds replace; run; data staff; set ds; informat BIRTHDAY ddmmyy10.; format BIRTHDAY date9.; where BIRTHDAY ne .; todays=put(today(),date9.); run;
data bday_today; set staff; bday=substr(put(BIRTHDAY,date9.),1,5); tday=upcase(substr(todays,1,5)); if bday=tday; run;
proc sql; select count(distinct MAIL_ID) into :emailcnt from bday_today; %let emailcnt = %cmpres(&emailcnt); select distinct MAIL_ID into :email1 - :email&emailcnt from bday_today; quit;
%macro mail; %if &emailcnt gt 0 %then %do i = 1 %to &emailcnt; filename Myemail email from = "ravindranadh044@gmail.com" subject = "!!! BIRTHDAY ALERT !!!" attach=("/home/u61914035/import files/0d01cc9cebe2e8de8b60d8fbf6ee47bc.gif") to = "&&email&i" type = "text/html";
data null; file Myemail; set bday_today(where = (MAIL_ID="&&email&i")); put 'HAPPY BIRTHDAY' ; RUN; %end; %mend; %mail;
... View more
