Auto reminder mail in VBA based on data in excel

Question

Hi,

i want to put a process ..we have formal RO process for radio industries.....when we don't have formal RO ..we book the deal and they promise to send formal RO in in a day or two....if we don't receive formal ro in a two days then we need to send a auto reminder mail to sales person regarding formal RO pending. we update daily excel sheet for that...but I want email to be sent auto. though .vba and database in excel sheet

Column Field is...

i want to send automail with email is Dear Waris,

This is a reminder that the formal RO for RO ID %% promised on %% is still pending. Please send it as soon as possible.

Advertiser: