If an employee does not have an email address entered then his/her Salary Slip will be printed rather than emailed.ĭepending on computer system the code will take approximately 45 seconds to create and email all the salary slip pdfs. 6 thoughts on Salary Slip for 30000 per Month in Excel & PDF (with Breakup) Pronoy talukdra. Sample Email for Sending Documents to HR After Interview. Job Transfer Request Letter Due to the Parent’s Illness. Note that I added a column to the Employee information sheet for the email address of each employee. Categories Templates Tags 30000 Rs pay slip in India, pay slip format in Excel, Salary slip for 30000 per month. Set OutApp = CreateObject('Outlook.Application') ExportAsFixedFormat 0, sFn, 0, 1, 0,, , 0 SPn = ThisWorkbook.Path & '\Salary slips - ' & sMnth & '\' 'Attached please find your Salary slip for ' & sMnth & _ Your employees can log on to check Pay Slips or update their personal details. Y = Sheets('Payroll calculator').CurrentRegion.Columns(4) X = Sheets('Employee information').CurrentRegion
