execute same module / sub every day in VBA

[Davefromlondon]

Hi. I have built a sheet containing multiple email addresses in multiple rows (with other data in columns including a "send date") and I have built a VBA module containing a subroutine that send the emails based on a date column ie if send date = system date (today date) then send email. works great.

I seek to run the same module / sub every day, in other words, tomorrow a different email will be sent if the send date matches tomorrows date. Seems I should be able to run a module every day ?

 

[silentwolf]

Hi,
Create a class to do things like that.

HTH

 

[MARK858]

Or use the Windows Task Scheduler.