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.


Member Opinions In This Discussion
Kavitha Janya
India, Bangalore
India, Madras
Salary Processing,final Settlements,medical
India, Bangalore
Akshu Puri
India, Chandigarh
Mba (hr)
India, Madras
India, Bangalore
India, Ahmadabad
India, Hyderabad
India, Hyderabad
India, Thana
India, Bangalore
+16 Others

Hi Rajasekar, Can you explain me about the mail merger option. How do I go about it and what are the steps.
Mail merge is option where you can merge the word file and excel file. You just have your salary structure format in word file and using mail merger import datas from the excel file.
Else u call me at 098401 80725

Hello Sir i tried to find mail merge option in excel but all in vain .... could you pls guide me abt this option like where is it in excel i know abt word but nt excel. Regards Akshu
Dear All

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

Outsource to Talentpro. We have one of the best payroll system in India. You can concentrate on you key functional area You can mail me to for more info.
Hi All,

Thanks for your replies, can anybody provide me the template of the mail merger, i just treid but not working, please provide the step by step details adopt mail merger for sending salary slips.


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.
Dear Indresh, I’m forwarding the format for making the salaries in MS Excel sheet. You modify it what you can wish. Regards, Krishnam Raju
Attached FilesProvided by community member krishnarfc. Register to join your network of peers.
File Type: xls Salary Statement.xls (292.0 KB, 13008 views)
Hi Indresh, u can download the trial version of pdf convertor and convert your excel sheet into pdf format and use as pay slip.


Found This Useful? +Vote Up This 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.

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network