Forum Discussion

A_SIRAT's avatar
A_SIRAT
Iron Contributor
Dec 19, 2019
Solved

Help with Excel

Hi ,   Is it possible to design one printable payslip template that will link to the Salary Data Sheet and when you hit the print button, it prints all the information from the Salary Data as long ...
excel
  • A_SIRAT's avatar
    A_SIRAT
    Dec 20, 2019

    Thank you Mathetes.

     

    I find the Mail merge solution better as you said.Appreciated.

mathetes's avatar
mathetes
Gold Contributor
Dec 19, 2019

A_SIRAT 

It's possible to write a VBA macro -- I did it once about 18 years ago -- to run through a database like that and fill in the second sheet (using VLOOKUP for the specific lines.

 

HOWEVER, you might find using the Excel database with Microsoft Word's Mail Merge capability to be even better. I know that's what I'd do if I were in your place. You don't need to write any code to do this; just link the Excel sheet with a Word mail merge template. In fact, with Mail Merge you can add individual messages automatically when, for example, some employee has met (or failed to meet) a minimum (or maximum) number of hours, or whatever. 

 

  • A_SIRAT's avatar
    A_SIRAT
    Iron Contributor
    Dec 20, 2019

    Thank you Mathetes.

     

    I find the Mail merge solution better as you said.Appreciated.

Resources