Indresh Started The Discussion:
Hello,

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.


Regards

Indresh.
4th March 2009 From India, Bangalore

Hi Rajasekar, Can you explain me about the mail merger option. How do I go about it and what are the steps.
4th March 2009 From India, Bangalore
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

Regards
Rajasekar

4th March 2009 From India, Madras
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
4th March 2009 From India, Chandigarh
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

Regards
venkatesh
Chennai
4th March 2009 From India, Madras
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.

Regards

Indresh.
5th March 2009 From India, Bangalore
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.
5th March 2009 From India, Bangalore
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
5th March 2009 From India, Hyderabad
Attached Files
Shared By Cite.Community Member "krishnarfc"
File Type: xls Salary Statement.xls (292.0 KB, 15418 views)
bmchr 
Hi Indresh, u can download the trial version of pdf convertor and convert your excel sheet into pdf format and use as pay slip.
5th March 2009 From India, Bangalore
I agree with some who say that this is not worth wasting time.
All I would say is, Friends, let us not forgo our exploratory streak. Solutions are available in MS Office in the form of Help (F1). Let us explore.

Actually, the payslip should be designed in MS Word and the data should be fetched in using Mail Merge. You can even put the company logo / other graphics / Some good quotes in the header / footer.

Try it out, it is very easy and time saving.

Regds.
Ranjit J. Pandya
5th March 2009 From India, Ahmadabad





 
 
 
 







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+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network