Hi dear,
First of all thanks to all that you helped me all-time before, when I face any difficulties.
Now I have a problem on mail merge that I have a list of Management staff salary. I have to create a pay slip file where in 1 page I have to print 6 staff pay slip.
Here is Staff Salary sheet image:
I attach my word file of pay slip
First of all thanks to all that you helped me all-time before, when I face any difficulties.
Now I have a problem on mail merge that I have a list of Management staff salary. I have to create a pay slip file where in 1 page I have to print 6 staff pay slip.
Here is Staff Salary sheet image:
| Management Salary CAL.xlsx | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | |||
| 1 | Section | Code | Name | Grade | Designation | Joining | Bank Ac | Basic | House Rent | Con. | |||
| 2 | Accounts | 00025165 | Md Abdul Alim Chy | 692 | Sr.Officer(Accounts) | 01-SEP-08 | 000234136057 | 18250 | 9125 | 2000 | |||
| 3 | Admin | 00075289 | Mohammad Nurul Islam | 4321 | GM | 15-APR-15 | 0100199492360 | 108975 | 54488 | 2000 | |||
| 4 | Admin | 00000008 | Syed Junaidul Alam | 1166 | Manager Com & HRD | 22-MAY-04 | JBL | 000234120894 | 30100 | 15050 | 2000 | ||
| 5 | Admin | 00049344 | Taslima Akter | 474 | Sr. WELFARE OFFICER | 01-MAR-12 | 0100057108481 | 12800 | 6400 | 2000 | |||
| 6 | Admin | 00103684 | Arpan Das | 322 | Executive | 09-DEC-20 | 0100219333581 | 9000 | 4500 | 1600 | |||
| 7 | Commercial | 00012564 | Md. Ashaduzaman | 1186 | Manger (Commercial) | 01-JUN-06 | 0100001258855 | 30600 | 15300 | 2000 | |||
| 8 | Commercial | 00010744 | Md. Mosharraf Hossain | 1168 | Manager (Commercial) | 01-MAR-06 | 000234125761 | 30150 | 15075 | 2000 | |||
| 9 | Cutting | 00000111 | Bishawzit Barua | 920 | Deputy Manager (Cutting) | 01-JAN-01 | JBL | 000234128269 | 23950 | 11975 | 2000 | ||
| 10 | Cutting | 00000115 | Md. Lablu Islam | 872 | Asst.Manager(Cutting) | 01-JUN-03 | JBL | 000234128244 | 22750 | 11375 | 2000 | ||
| 11 | Cutting | 00105485 | Rupan Kumar Dey | 842 | Manager | 01-JUN-21 | 0100224242926 | 22000 | 11000 | 2000 | |||
| 12 | Cutting | 00000382 | Md. Mahbub Rahman | 644 | In-Charge (Cutting) | 10-SEP-03 | JBL | 000234139679 | 17050 | 8525 | 2000 | ||
| 13 | Cutting | 00000423 | Md. Zahirul Islam | 434 | Executive (Cutting) | 06-SEP-04 | 0100165838771 | 11800 | 5900 | 2000 | |||
| 14 | Dedicated Quality Assurance | 00062101 | Sanchay Barua | 444 | Jr.Executive (D.Q.A) | 02-JUN-13 | 0100166184783 | 12050 | 6025 | 2000 | |||
| 15 | Dedicated Quality Assurance | 00089415 | Sahadat Hossain Chy | 377 | Executive | 15-APR-17 | 0100230635743 | 10375 | 5188 | 1600 | |||
| 16 | Finishing | 00000097 | MD ABDUL KADER | 1411 | Manager (Finishing) | 26-JUN-86 | JBL | 000234119193 | 36225 | 18113 | 2000 | ||
| 17 | Finishing | 00104025 | Md. Babul Uddin | 629 | FINISHING IN-CHARGE | 02-JAN-21 | 000234134614 | 16675 | 8338 | 2000 | |||
| 18 | Finishing | 00000132 | Md. Belal Hossain | 593 | Sr.Executive(Fin) | 22-JUN-00 | 000234134589 | 15775 | 7888 | 2000 | |||
| 19 | Finishing | 00016645 | Shamim Chowdhury | 462 | In Charge | 14-APR-07 | 0100115734312 | 12500 | 6250 | 2000 | |||
| 20 | Finishing | 00016127 | Md. Hasan | 449 | Sr.Executive (Finishing) | 04-FEB-07 | 0100165670781 | 12175 | 6088 | 2000 | |||
| 21 | Finishing | 00000490 | Amzad Hossain | 434 | Executive (Finishing) | 01-JUN-04 | 0100115818117 | 11800 | 5900 | 2000 | |||
| 22 | Finishing | 00010155 | Shafiqur Rahman | 432 | Executive (Finishing) | 01-FEB-06 | 0100165890501 | 11750 | 5875 | 1800 | |||
| 23 | Finishing | 00033685 | Md. Ariful Islam | 384 | Executive (Finishing) | 07-MAR-10 | 0100230636405 | 10550 | 5275 | 1600 | |||
Sheet1 | |||||||||||||
I attach my word file of pay slip
