Hi,
I'm still somewhat new to VBA and even newer to integrating it with outlook. Appreciate any help.
I have an email message archived on my network, let's call it TestEmail. The subject of said email may or may not include the string "UPDATED" to represent a change in a portfolio. There are also two variables included in my code, which will change depending on whether or not the subject includes the aforementioned string.
The email subject will either be:
"5/19/2020 Trading - NO CHANGE, Exposure: 44%"
or:
"5/18/2020 Trading - UPDATED EXPOSURE TO: 44% FROM: 39%"
I originally tried an IF statement along with MID function (shown below) because i was under the impression the structure/formatting of the subject wouldn't be changing, but now it seems like that's not true. What will NOT change is the first part (MM/DD/YYYY - Trading")
All of that said, based on the above email subjects, what's the best way to grab the appropriate numbers?
The goal is the below:
For the 5/19 email:
PriorDaySignalEmail = 44 =CurrentDaySignalEmail
For the 5/18 email:
PriorDaySignalEmail = 39
CurrentDaySignalEmail = 44
Thanks again!
Bookmarks