Indresh Started The Discussion:
Can anybody tell me how to generate the payslip from excel sheet or is there any other option. I want to generate from Salary Master Sheet, so every month I dont need the change the values in salary slip.
Payslips can easily be generated through Microsoft word > Tools > Letter & Mailings > Mail merger. It is one of the easiest way you can generate payslip as per the required format from excel to word. If any one needs help pl reach me at 9841160500. I am here to help you friends
Let me try explaining the step by step process of Mail Merge...
1 - Form a template in a word document.
Example: Dear Mr. Name, Your employee number is: Emp No, You would be earning a CTC of: CTC
2 - Open an Excel Sheet which contains the information for all the MS word fields: Example:
Name Emp No CTC
ABC 123 10,000
CCC 458 20,000
SSS 666 15,000 and so on
3 - In word click on Tools - Letters and Mailings - Mail merge wizard. A screen will pop up on you word document showing Mail Merge heading.
4 - On bottom right corner you will find "Starting document" link which will be colored in Blue. Click on the link. You will be directed to "Select recipients" link. Click on "select recipients" You will next be directed to " Browse" link.
5 - Click on "Browse" it will ask you to select the document to which you need to merge. Select the data source. you need to select the Sheet number in which your main data is stored. Click "Ok" Minimise tehe Excel sheet. and open the word document.
6 - In word document select the word "name" Example: Dear "name" and select on insert merge field icon (you can find the icon in MAil merge toolbar). as soon as you click the icon you will get a window which will ask you to choose the field for which you need to merge.
7 - Select the appropriate field and click on Insert button.
8 - Then close.
Similarly for Emp No and CTC. after finishing the entire process you can view the final results when you click on "view merged data" icon
I hope i have explained Mail merge in brief. Let me know if you find any hurdles while merging the document.
Found This Useful? +Vote Up This Page Via Google.
Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.
Explore Topical Knowledge Areas
Topic Categories >> salary structure payroll outsourcing salary slip payroll software ms excel salary sheet automated payslip pay slip salary slips Location-India-Bangalore payroll system payslip format mail merge payroll in excel Complete List Of Categories
Interesting Relevant Discussions