VB Code that can change the color of my sub query
I am using SQL sub query and I have a list of email addresses on it. These are the list of the customer’s software that will expire in 45 days or less. With just a single click, an email will be sent to the customers address. What I want to do now, is to make a formatting that will change the font color of my list when an email is sent. In this way, anyone who uses this database can easily view if the email has been sent to a specific customer at a later date. Is there a simple Visual Basic code that I can put into the email script and will turn those sent addresses to green color on my sub query?