I have multiple excel files. Data files to load data to an application.
Each time data is loaded and saved, An order is created in the application. Email notification is done and moved to next file.
Say in the data file, customer number is incorrect. Incorrect customer will only be captured once we try to load it in application and we get
In this case i would send apt email notification and move to the next data file for processing.
How do i achieve this?