Hi,
I have to automate a program where whenever I receive an email with header "Item Number change: Rice 2 lbs" and the message says "Price for item 10023456 has been changed to $2.99"
I would like to extract this kind of specific emails from my emails and then extract item number (100023456) and price (2.99) and store it into temporary table or session and use this information to change the value in the database. Instead of opening database manually and change the price.
If you guys have any idea how it can be done, please let me know. Thanks for your help in advance.
...
Go to the complete details ...