How to automatize Salary slip preparation using EXCEL and a WORD-template?

I want solution to automatize "Employee Salary Slips" by using MS word and MS Excel. I usually prepare an Excel list comprising all the employeeID's, employee name and their salary (split in 4 columns). I pass on this list to my assistant, who manually enter all the data one by one into Word template.

I want to automatize this, by using either Macros, VBA or mail-merge. I don't know whether this can be done or not.

If anyone can tell me if the problem can be solved, I'll do a bit of research and try to do it.

I'll be very gratefull if anyone can provide a sample. That would make my work more easier.

Thanking you in advance,

Ravi.

this can be done with mail-merge in Word.
Tools -> Letters and mailings -> Mail merge

The Whizard should guide you thru this step by step.
It lets you select "Use an existing list" and then "Select a different list"
This lets you select your excel file, the sheet containing your list, and the fields you want to merge.
Click on "More items" when you want to insert a field. This gives you a list to select from.

Just try for yourself. I think it is pretty much self explaining.