Dynamic Printing_(or Mail Merge)

[Vishal Srivastava]

Dear Friends,
As per my client requirement, I prepared a payroll system in excel for his company. In which payslip is a dynamic one. It means just enter emp code , salary will be shown individually.

But my client wants to have printing of all employee's payslip in one shot. He doesn't want to type manually for all employee. In word, there is an option named mail merge. but how can I do the same in Excel?

Please help!

Thanks & Regards,
CMA Vishal Srivastava

 

[Hui]

Vishal

You need a simple piece of VBA to step through a list of names/ID's, update the payslip, then print it
This is a great starter project if your not familiar with VBA

Posting the file will help us help you

Randomise the names or data to ensure it is anonymous