How to send an email to each row for specific date?
Posted on 2003-02-26
I have a table "CustomerInformation". In it I have several fields, 3 notable ones, "Email", Tracking", and "DateEntered".
I want to send emails at the end of the day to each row (person) that has a "DateEntered" of today. In each email I want some generic text, and I want to include the field "Tracking". The email will be sent to "Email" email address.
I can't seem to figure out how to do this. Any suggestions?