Hopefully this can be done ... using Oracle/Outlook.
I have a table called "Customers" that contains (CustID,CustName,CustEmail) and I have an "Orders" table of (CustName,Order_Quantity,Order_Date,Order_Total, etc).
What I want to do is have an Application that will go through the "Open Orders" table on request and email confirmation. Specifically, tab through the "Orders" table and get the email address for a specific customer and Email a confirmation or current status of that order. So if there were 100 "Open Orders" than 100 seperate emails would be sent based upon CustEmail data.
I know I can create a view to get the CustEmail address in a table with the Open Orders via Customer Name but am not sure of the rest. Thanks for you time ...
I have a table called "Customers" that contains (CustID,CustName,CustEmail) and I have an "Orders" table of (CustName,Order_Quantity,Order_Date,Order_Total, etc).
What I want to do is have an Application that will go through the "Open Orders" table on request and email confirmation. Specifically, tab through the "Orders" table and get the email address for a specific customer and Email a confirmation or current status of that order. So if there were 100 "Open Orders" than 100 seperate emails would be sent based upon CustEmail data.
I know I can create a view to get the CustEmail address in a table with the Open Orders via Customer Name but am not sure of the rest. Thanks for you time ...