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.
VBA developer since 1997. Let's do it now. Regards, Svet
Bu iş için 7 freelancer ortalamada $34 teklif veriyor
Hi, There must be an option for multiline matching which you should use for the same purpose
Exceptional quality & Quick work. Please refer to Profile & Reviews for quality of work. Thanks FAZ
Hi Tex, with my experience in VB and regular expressions, this should be an easy job. Best regards, Nuno