vincetaylor
Senior Member
- Outlook version
- Outlook 2016 64 bit
- Email Account
- Exchange Server
I need to validate an outlook form using an an "OR" statement.
When I validate without "OR", the formula below works. The form is not sent and the appropriate error message appears.
([Number] <>"1" )
But when I try to make it a compound validation by using "OR", the validation does not work.
([Number] <>"1" ) OR ([Number] <>"2" )
The form is sent and the appropriate validation message is not displayed.
I have tried to use the symbols "||" instead of "OR". That doesn't work at all. I get an Outlook generated error message that has nothing to do with the issue
My end goal is to use "OR" and "AND" in the same formula so I would also appreciate any help with "AND"
The end formula should look like this:
([Number] <>"1" ) OR ([Number] <>"2" ) AND [Letter] <> "A"
I would appreciate help with one or both issues.
When I validate without "OR", the formula below works. The form is not sent and the appropriate error message appears.
([Number] <>"1" )
But when I try to make it a compound validation by using "OR", the validation does not work.
([Number] <>"1" ) OR ([Number] <>"2" )
The form is sent and the appropriate validation message is not displayed.
I have tried to use the symbols "||" instead of "OR". That doesn't work at all. I get an Outlook generated error message that has nothing to do with the issue
My end goal is to use "OR" and "AND" in the same formula so I would also appreciate any help with "AND"
The end formula should look like this:
([Number] <>"1" ) OR ([Number] <>"2" ) AND [Letter] <> "A"
I would appreciate help with one or both issues.