Looking for help with a MS Outlook VBA macro that extracts data in e-mails. The macro uses regular expressions to extract data and works great for most situations, but there's one line that doesn't work:
Const PATT_SHIPPING_NAME As String = "^\s*Ship To:\s*:(.+)$"
The issue is that the information that needs to be extracted isn't on the same line of the 'Ship To:' text. In other words, I'm trying to extract the shipping name that's on the second line in the following:
Unfortunately, my experience with regular expressions is quite limited and I can't figure out how to handle the linebreak (\n?) and then retrieve the information on the next line. I'm on a time crunch so am posting this project here.