Skip to main content

Batch Email

note

Make sure you had done setting the template in Maintain Employee.

Setting in Maintain Employee

You can CLICK HERE to go Batch Email Link

  1. Click on 3.2.2 Version 1.2021.196.166 & above

    wiki-batch-email

  2. Scroll down until see this Sample E-Mail Template (Version 1.2021.196.166 & above) > Click on Expand

    template

  3. Copy all

    copy-template

  4. Open your SQL Payroll System

  5. Navigate to Human Resource > Maintain Employee and click New

    new

  6. Click 🔽 beside More

    more-dropdown

  7. Click on Paste Employee

    paste-employee

  8. After Paste Employee you will see Employee Code as EMAIL and the PDF Password Setting at Note

    paste-employee-result

Setting PDF Password

Scenario 1 : Setting Employee Name 2 as password

note

Only available in Version 1.2021.2066.174 & above

  1. At Note Tab:

    • [UseName2] Put 1 to enable it
    • [GlobalPassword] and [PrivatePassword] make sure is empty
    [UseName2]
    1

    [GlobalPassword]

    [PrivatePassword]

    employee-name-2-pdf-password-1

  2. Under Employee profile set the password at Name 2

    For Example : testing is the PDF Password

    employee-name-2-pdf-password-2

Scenario 2 : Setting Global PDF Password by UseName and ICPass

_UseNameICPass - This setting is to use Employee Name and IC set as PDF password

  1. At Note Tab:

    • [UseName2] Put 0 to disable it
    • [PrivatePassword] is empty
    [UseName2]
    0

    [GlobalPassword]
    UseNameICPass

    [PrivatePassword]
    EmployeeCode=Password
  2. The first character of Employee Name (In Uppercase)

  3. Second character is @

  4. The subsequent 6 characters is the last 6 digits of NRIC or Passport Number

    For example :

    Name : LEE CHONG WEI

    NRIC : 961212-01-4321

    The password is : L@014321

    global-pdf-password-usename-ic-pass

Scenario 3 : Setting Global PDF Password

info

This settings configures all employees to have the same password

  1. At Note Tab:

    • [UseName2] Put 0 to disable it
    • [PrivatePassword] is empty
    [UseName2]
    0

    [GlobalPassword]
    BatchEmail

    [PrivatePassword]
    EmployeeCode=Password
  2. set the PDF Password below [Global Password]

    For example as below :

    The PDF Password is ‘BatchEmail’

    pdf-password-global

Scenario 4 : Setting Private/ Individual Password

note

Private Password - Each Employees got their own PDF Password

Must set for all Employees

  1. At Note Tab:

    • [UseName2] Put 0 to disable it
    • [GlobalPassword] is empty
    [UseName2]
    0

    [GlobalPassword]

    [PrivatePassword]
    EmployeeCode=Password
    001=LEE
    002=KOO
  2. Under [PrivatePasssword], put employee code and their password following the format below:

    Format : EmployeeCode=Password

    For Example as below :

    001=LEE ('LEE' is the PDF Password)

    002=KOO ('KOO' is the PDF Password)

    pdf-password-individual

Send Payslip by Batch Email

E-Mail Client (Batch)

note

Make sure your pc had install window email (Ex : Outlook or Thunderbird)

  1. Go to Payroll > Print Pay Slip ...

    email-client-print-payslip

  2. Filter your process you wish to batch email > Apply

    email-client-filter

  3. Click 🔽 Beside Printer icon

  4. Click on Export to E-Mail Client (Batch)

    email-client-more

  5. Select your payslip format > OK

    email-client-select-payslip

  6. After click ok will prompt window and show has been sent to recipient email, mean success send out

    email-client-send

E-Mail SMTP (Batch)

note

Make Sure you had create App Password

  • If you’re using Gmail , you can CLICK HERE to create your App Password
  1. Go to File > Company Profile

    smtp-company-profile

  2. Select Email Setting from the tabs

  3. Fill in your email detail

    **Password : Is your App Password

    smtp-app-password

  4. Go to Payroll, click Print Pay Slip

    smtp-print-payslip

  5. Filter your process you wish to batch email > Apply

    smtp-filter

  6. Click 🔽 Beside Printer icon

  7. Click on Export to E-Mail SMTP (Batch)

    smtp-export

  8. Select your payslip format > OK

    smtp-select-payslip

  9. After click ok will prompt window and show has been sent to recipient email, mean success send out

    smtp-send