​​casestudy-banner

Error-free, Automated Email Alerts

Alert Email Automation

HR department is responsible for sending notifications for activities that include birthday and anniversary wishes, passport and visa expiry dates and contract expiry date, daily, by checking the excel spreadsheet.

To send birthday and anniversary wishes, the HR executives have to extract data from the Employee Management application and fill the details in the excel sheet followed by filtering the employee birthday dates from excel. The template dedicated for birthday wishes is then filled with necessary credentials and finally mails are floated across the organization.

For sending passport, visa and contract expiry date notification, data has to be extracted from the EPE application and the information is filled in the excel sheet. This is followed by filtering the employee passport, visa and contract expiry dates from the Excel.