Email different people based on rows in spreadsheet
Posted on 2011-04-29
I have payroll information in each row of a spreadsheet:
Employee email address
Sick Time Accrued
I would like to be able plug stuff in the spreadsheet and then run an automated routine (preferably in VBA), to send the information in each row to each individual employee and keep individually sending each row until there is no Employee in there. Can anyone help me out? Also, this would have to be pretty bulletproof, because don't want to piss employees off by showing how much another employee has available. Or maybe I shouldn't include their name in the email, so they wouldn't know who it was in case it screwed up? Thanks for your help.