Validating Form testing 2 Conditions

Status
Not open for further replies.

Mel-4-short

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hello,
I am trying to test whether or not:
If the field "Invoice" (i have an option button bound to it) is empty AND the TO: field is not equal to an address, then display error. Here's the latest code I've tried:

IIf(([To]<>"mailaddress") AND ([invoice]<>"")) OR (([to]<>"mailaddress")AND([Invoice]<>"")))

I've tried numerous ways without parenthesis, etc., but no luck. Is this even possible?
Thanks so much!
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Oh. It might be the double negative. If To does not = address1 OR it does not = address2, it's always going to pass, as one is always going to be true. (Plus, it might fail if there is more than one address in the to field. )

This seemed to work here (i didn't have an invoice field to check :)) but then I remembered the double negatives. I am getting messages marked true.
IIf(([To]="address1" Or [To]= "address2") And [Last Verb Exec Type]="102","True","False")

This also seems to work, but i don't have a good test set so i could be wrong on the address expression.
IIf(([To]="address1" Or "address2") And [Last Verb Exec Type]="102","True","False")

If you need to use <> , try using 3 iif's
IIf( invoice = "", IIf(if to <> address1, "is true", iif(to <> address2, "is true", "is false"))
 

Mel-4-short

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Thank you so much for the quick reply. I think I should have explained what I was doing better.
-I would like to have person 1, send an invoice approval form with an attachment to person 2. (Acctspay person)
-Person 2 approves (Click yes to pay & click yes to close PO).
-Person 2 forwards the form back to person 1 with their approvals (I need to validate and make sure 2 fields are not empty.)
-Person 1 forwards the form to person 3 with the approvals, the final resting place.

Issues I'm having:

I can use the easy validation method but when person 1 sends the form, it validates those fields and we don't want that quite yet. ONLY if the form is being sent to 1 of 2 addresses.

My workaround for that is I creating another form where the only change from a message form is that I called my Invoice Approval form on the forward action. The validation works beautifully, however, anything person 1 or 2 puts in the message field is not saved after forwarding (I'm assuming because it keeps calling a new Invoice Approval form).

My next thought is to go back to using 1 form, and trying to using a formula for my validation instead of just testing if it's empty.

So, I'd like to use the formua and 1 form. The formula I tried doesn't error but doesn't work either.

:) I so appreciate you and your help. Thank you!
-Mel
[DOUBLEPOST=1418135543][/DOUBLEPOST]IIf(([To]="mailaddress" Or "mailaddress") And [invoice]<>"")

The logic here seems correct, but doesn't seem to work...
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I think you'll need to use 1 form and a formula. Unless you also pull in the message body field when you create the invoice form.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
V Validating Outlook form with "OR" and "AND" Outlook VBA and Custom Forms 1
R Validating a group of Checkboxes Outlook VBA and Custom Forms 2
Witzker How to get the button Karte ( map) in custom contact form Outlook VBA and Custom Forms 2
B Outlook 2019 Custom Email form - Edit default email form Outlook VBA and Custom Forms 6
C Populate form data into message body Outlook VBA and Custom Forms 1
Witzker Outlook 2019 How to get a Photo in a User Defined Contact form Outlook VBA and Custom Forms 2
Witzker Outlook 2019 Macro to send an Email Template from User Defined Contact Form Outlook VBA and Custom Forms 0
Witzker Set Cursor & Focus from any field to the body of a user Contact form in OL 2019 Outlook VBA and Custom Forms 1
Witzker Place cursor at opening, a user defined OL contact form Outlook VBA and Custom Forms 3
T Customized form: The Forward option shows write layout Outlook VBA and Custom Forms 0
T 1:1 Datatransfer from incoming mail body to customs form body Outlook VBA and Custom Forms 0
V Latest Changes to form not appearing for some users Outlook VBA and Custom Forms 3
J Does the .fdm contain my custom form? How to make ol use it? - ol2007 Outlook VBA and Custom Forms 4
J ol2021 custom form not displaying pics Outlook VBA and Custom Forms 37
bdsermons Outlook 365 command button in outlook form Outlook VBA and Custom Forms 5
wayneame Changing the Form Used by Existing Task Items in a Folder Outlook VBA and Custom Forms 4
N Contact Form Notes Field Touch vs Mouse Using Outlook 0
cbufacchi Outlook 365 Populate custom Outlook Appoint form Outlook VBA and Custom Forms 2
C Create Meeting With Custom Form Outlook VBA and Custom Forms 2
W Designer Form 2013 and Script ? how ? Outlook VBA and Custom Forms 1
J Read Outlook Form fields Outlook VBA and Custom Forms 3
V Compound IF, OR, AND in Outlook form Outlook VBA and Custom Forms 4
J custom form not displaying pictures Outlook VBA and Custom Forms 7
I Button PDF in Outlook Contact custom form Outlook VBA and Custom Forms 1
K Font Sizing in Custom Form Regions for Contacts Outlook VBA and Custom Forms 1
M Outlook 2010 How could I globally redesign an outlook template form/region/inspector template used to display mail lists or an individual mails? Outlook VBA and Custom Forms 0
A How to stop user form from disapearing once mail window is closed? Outlook VBA and Custom Forms 0
K can't get custom form to update multiple contacts using VBA Outlook VBA and Custom Forms 3
V Form data not sending for some users Outlook VBA and Custom Forms 2
H Custom Outlook Contact Form VBA Outlook VBA and Custom Forms 1
Witzker HowTo Change message Class of contact form Outlook VBA and Custom Forms 0
A VBscript stops running after updating form Outlook VBA and Custom Forms 1
Witzker HowTo start a macro with an Button in OL contact form Outlook VBA and Custom Forms 12
D Emailed form is blank Outlook VBA and Custom Forms 0
F Validation on custom task form after task acceptance Outlook VBA and Custom Forms 1
C Add Form to Appointments Received, Automatically Outlook VBA and Custom Forms 6
V Date and/or time error in Outlook Form Outlook VBA and Custom Forms 0
A Form Position with Dual Monitors Outlook VBA and Custom Forms 2
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
M VbScript for Command Button on Contacts Custom Form Using Outlook 1
G Other users can't see P.2 with custom fields in Form Outlook VBA and Custom Forms 0
O Create a custom contact form - questions before messing things up... Outlook VBA and Custom Forms 4
L Custom Form Tutoral? Outlook VBA and Custom Forms 6
D Lost Access to Custom Form Outlook VBA and Custom Forms 4
A Form style totally changes Outlook VBA and Custom Forms 2
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1
S Outlook Custom Form Scripting only working when clicking on "Run this form" Outlook VBA and Custom Forms 2
V Making a Date field mandatory in outlook form Outlook VBA and Custom Forms 2
R Add 'Company' to Select Names Form Using Outlook 1
Victor_50 Outlook 2013 Custom Contact Form starts with "E-mail 2" Outlook VBA and Custom Forms 2

Similar threads

Top