- What is the Paysplip Sender ?
An Excel VBA application which automatically sends the Payslips each month to all employees in Password Protected PDF file.
- How it works ?
1) The HR user inputs in sheet Send all employees with ID, Name, E-mail, Password for PDF file with the Payslip and the Year and Month:
2) HR User imports into the sheet Data_base the amounts for all active employees from sheet Send:
3) In sheet Fluturas_salariu we have the Payslip. The amounts are changed with formulas. The reference is the employee ID:
4) HR User goes to sheet Send and presses “Send”. Then he/she must choose to send the payslips to all employees or only to some employees.
5) After HR user presses “Yes”, the application automatically generates and sends via Outlook e-mail each Payslip in PDF password protected file. The HR user can also see the progress with a Custom Made Progress Bar. (please see bellow). The application does not send any payslip if some correlation conditions are not met.
At the end, the user reveives a message regarding the running time of the application. It takes approximately 2-4 seconds / paysplip to be saved and sent:
–> Some sample printscreens of the VBA code which does all the work:
1) Save all pdfs and Send all e-mails code sample:
2) Save pdf with password with PDF Creator code sample:
3) Send_emails_code_sample:
4) Function for checkings code sample:
!!! Important Note: All Sample Projects posts are examples of some apps created by me from beginning to end. All customer private data are hidden, the aim being to present briefly the app’s features, ideas, methods used etc.
