I am a complete novice to VBA but know this must be possible. I place orders and receive 3 emails back regarding the same order which I need to update a spreadsheet. Once order is placed I enter the order number in the spreadsheet, then receive an email back confirming they have received it. I need to update the spreadsheet with the date of this email, in a specific column and move the email to a folder in outlook which can be found by a column in the excel spreadsheet. Each title of these emails are different so I need to look at the email title and update the specific column with a date by looking up the order number in the spreadsheet.
First email - Subject - Case ID "order number" | lots of other words | Case Raised
Second Email - Subject - Case ID "order number" | lots of other words | Your request is updated
on the second email if the body of the email states we will email you once we receive confirmation I need to insert the date into the spreadsheet.
or if the body of the email contains "I have reviewed the case but unfortunately" I need to deal with the email and not enter a date
Third Email - subject - Case ID "Order Number" | lots of words | your request has been completed on this one I need to insert a date into a column but flag the email for me to do something with it in 5 days.
Hope this makes sense.
Thanks
Dawn