I am trying to do up a VBA script to auto forward emails based on the content of the email.
Scenario 1: if ‘apple’ and ‘iphone’ are detected in the email body, foward the email to abc@email.com
Scenario 2: if ‘apple’ and ‘iphone’ and ‘sold out’ are detected in the email body, forward the email to abc@email.com, xyz@email.com and apple@email.com
Tried creating rules for this but outlook rules only process them as an OR rule instead of an AND rule.
Got 0 knowledge on VBA but am trying to learn.
Appreciate any form of help for this!