macro for sending emails to employees on a particular date of each month

[hiteshdemla]

Hi All

I have a list of employees with their email IDs and a date on which their salary slips should be emailed to their respective IDs and other details, in an employee database. I want to have a button so that excel matches the current date with dates specified for salary slip dispatch and send salary slip email if there is a match.

Salary slip is a worksheet which has a standard template and specific details like employee name, basic salary, etc are returned using vlookup from the employee database sheet.

pfa a sample sheet for more clarity.

Please suggest me through, if we could have anything on this.

Thanx