Showing results for 
Search instead for 
Did you mean: 

Mapix Outlook VBO

Level 2

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

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

Amol Jangam
Tech Lead

Level 12
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