Dear Seniors,,
I am preparing Salary statement in MS Excel .. Also generating Salary Slips thru Excel only. we have 300+ employees. I can print 2 salary slip(one page) at one time only. I want to print all the employees salary slips at by giving one command..
Also let me know please MS Excel is better or MS Access is better for preparation of Salary Statement.
U can email me.
Pls. guide and Help..
Rgds.
Arabindo (Personnel Officer, SLR Steels.)
& 
09341 660 990
From India, Mumbai
2I am preparing Salary statement in MS Excel .. Also generating Salary Slips thru Excel only. we have 300+ employees. I can print 2 salary slip(one page) at one time only. I want to print all the employees salary slips at by giving one command..
Also let me know please MS Excel is better or MS Access is better for preparation of Salary Statement.
U can email me.
Pls. guide and Help..
Rgds.
Arabindo (Personnel Officer, SLR Steels.)
09341 660 990
From India, Mumbai
Dear Arabindo,
Definitely this wont be the answer for your query related to printing payslips in excel or in access...!
Wanted to share my personal recommendation to you to consider any entry level payroll software to reduce your burden of preparing, printing, verifying and distributing payslips through office tools.
Also for your kind of 300+ employees (which is a decent size), please consider a self service module as well to induce your staff to generate leave requests, salary clarifications, stationary request...this will really boost your employees morale! (out of 300 if you have more labours, atleast your office & admin staff would appreciate!)
Pls contact me for any further assistance in this regard
Best regards
Senthil Kumar
09900617101
From India
Definitely this wont be the answer for your query related to printing payslips in excel or in access...!
Wanted to share my personal recommendation to you to consider any entry level payroll software to reduce your burden of preparing, printing, verifying and distributing payslips through office tools.
Also for your kind of 300+ employees (which is a decent size), please consider a self service module as well to induce your staff to generate leave requests, salary clarifications, stationary request...this will really boost your employees morale! (out of 300 if you have more labours, atleast your office & admin staff would appreciate!)
Pls contact me for any further assistance in this regard
Best regards
Senthil Kumar
09900617101
From India
Dear Arabindo,
The best way is software as suggested by few friends.
But If you know the MailMerge in Ms-Word, than you can make the format of Salary Slip in Ms-Word and attach the Salary Sheet of Excel to this word file. This way all the slips can be printed or mailed in one go.
In case any details are required you can contact on below linked mail or mobile.
Mobile :- 09873007726
I can forward the format also, if required.
Ashok Kumar
From India, Mumbai
The best way is software as suggested by few friends.
But If you know the MailMerge in Ms-Word, than you can make the format of Salary Slip in Ms-Word and attach the Salary Sheet of Excel to this word file. This way all the slips can be printed or mailed in one go.
In case any details are required you can contact on below linked mail or mobile.
Mobile :- 09873007726
I can forward the format also, if required.
Ashok Kumar
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
SALARY EXCEL.zip
Salary slip final.xls