Share via

How to Make Payslip for worker & staff when they r more than 1000 in number

Anonymous
2014-01-09T01:41:47+00:00

Hy every one hope u r all fine. I have prepared company worker & staff salary sheet by using excel 2010. but now i want to make a payslip for one of each them i dont understand how to do it can u advice me how can i over come this problem. please help me advance thanks for ur time

thanks & best regard

sohel

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2014-01-09T07:14:07+00:00

    The link I posted contains step-by-step instructions.

    Other tutorials can be found with a Google search for "office 2010 mail merge tutorial"

    For example

    If you get stuck with your project, feel free to ask.

    2 people found this answer helpful.
    0 comments

20 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-01-10T07:11:54+00:00

    Hello,

    You can enter static information as text into the Word document. For example

    Payslip for ABC Company

    Pay for the month of [Month field]

    Employee Name: [Employe name field]

    Salary: [Salary field]

    The idea with mail merge is that you combine static text, which will show on EVERY copy with the data fields that show the individual data items. So, if you want the text "Salary" to appear before the salary field, just type it into the merge document.

    0 comments
  2. Anonymous
    2014-01-10T03:30:11+00:00

    Good Morning mam hope u r doing well i have tried some tutorial its fine & i am doing fine. but one problem here all payslips only displaying columns information but not columns labels. For an examples. Its displaying Sohel 5000 4000 9000. but want like Name: Sohel Basic Salary 5000 Allowance: 4000 Total Salary & i have a common title for every Payslip My company Name & Salary for the month of December- 13

    Is there any way to do this, Thanks & Best Regard sohel

    0 comments
  3. Anonymous
    2014-01-09T03:26:32+00:00

    Mam is is there any tutorial that can help me

    0 comments
  4. Anonymous
    2014-01-09T02:52:52+00:00

    Hello,

    you can create the payslip in Microsoft Word. You can enter placeholders for the name and the salary and then use Mail Merge to pull the data from Excel and merge it with the Word file to print the payslips for individual people.

    Get started with mail merge in Office 2010 here:

    http://office.microsoft.com/en-nz/word-help/use-mail-merge-to-create-and-print-letters-and-other-documents-HA101857701.aspx

    0 comments