I need a script to extract the invoice number out of a email. The emails are always the same with a different invoice number.
Invoice 12345 needs your approval.
Invoice 23456 needs your approval.
Invoice 99999 needs your approval.
The invoice number is in the subject line of the email.
I would like to do this upon receipt of email as each email arrives. I can switch my email account to yahoo or google or any of the major services. I tend to use yahoo since I like Yahoo alerts when the email comes in.
I would like to post the invoice # to an Excel spreadsheet.
Reference your prior experience.
Turnaround time one week from acceptance.