topic RE: Mapix Outlook VBO in University Forum

Mapix Outlook VBO

MadhaviPathare — Wed, 06 Apr 2022 08:14:00 GMT

What syntax used to be for multiple subject lines?

For Ex. I want to read emails that are content with words like "RBC" and "BOA". It works if I put "%BOA%" alone but am not able to find out how I can combine both words in a single syntax.

------------------------------
Madhavi Pathare
------------------------------

RE: Mapix Outlook VBO

AmolJangam — Wed, 06 Apr 2022 09:42:00 GMT

You can try "%CFN% AND %BOA%"

------------------------------
Amol Jangam
Tech Lead
Infosys
Pune
------------------------------

RE: Mapix Outlook VBO

AmiBarrett — Wed, 06 Apr 2022 17:00:00 GMT

Despite the name, this isn't based on MAPIEx - this is really just an extended Outlook VBO (which still uses MAPI, it just doesn't use the wonky custom dll that's caused MAPIEx to be deprecated).

What you're attempting would probably be best accomplished by using the Filter Expression field, rather than the subject field.

"@SQL=urn:schemas:httpmail:subject LIKE '%RBC%' AND urn:schemas:httpmail:subject LIKE '%BOA%'"

Edit: But you'd also need to replace your 'Earliest' and 'Latest' fields with filter syntax. Read and Unread will also get replaced by the syntax, but since they're both True, there's nothing to add to the string for them. You should leave the 'Shared E-mail' field as-is.

"@SQL=urn:schemas:httpmail:subject LIKE '%RBC%' AND urn:schemas:httpmail:subject LIKE '%BOA%' AND urn:schemas:httpmail:datereceived>='" & AddDays(Today(),-7) &"' AND urn:schemas:httpmail:datereceived<='" & ToDateTime(Today())&"'"

------------------------------
Ami Barrett
Solution Architect
Karsun Solutions
Plano TX
------------------------------