Hello Chandoo,
I was doing this in MS Access. Everything was working beautifully. For some reason beyond my control, my company has got rid of MS Access when we had the hardware upgraded and we have been instructed to use only MS excel.
I have to create and email pay instructions to 60 offices...