I am looking for a program developed to extract certain info from the body of emails arriving in a specfic mailbox, this information whould then be analysed and inserted in a excel spread sheet.
The emails to be analysed will come from our customers providing a list of available haulage collections/deliveries.
The emails will be in a general inbox which will also contain non transport related emails and these should be ignored.
The emails are all in different formats for each customer but all should contain collection location, collection date, delivery location and delivery date. Due to every email being in a different format I am looking for an intelligent solution that can analyse the email, decide if its offering us haulage collections, determine which customer its from, determine the collection site and date, determine the delivery site and date and then pass this information to a formated excel spreadsheet.
Example emails attached and spreadsheet attached in the correct format, colums highlighted in blue must be populated form email.