Outlook Forms: Validation

Status
Not open for further replies.

cocolete

Member
Outlook version
Email Account
Hello,

I currently have started using the "Designed Forms" option in outlook. I have created a form but I'm trying to create a "validation" that limits the number of characters (whether numbers or letters).

I'm more of an excel user. In the Properties window, under the validation tab, I have written LEN(13) in the "Validation Formula". This would suffice in excel validation but it is coming up as an error in outlooks no matter what I write.

Does anyone have insights as to how to do this or knows if I'm going about it the wrong way entirely?

I appreciate any insight that is provided.

 
Also,

Once I have a form created and have succesfully sent an e-mail through it (I'm in test phase so I sent it to myself) how can I export that data into excel?

Right now I have to take and copy and paste each one individually.

Thank You
 
Hello,

Apparently that is not what I needed. It was my error.

I'm trying to make a validation that doesn't allow me to input anything over 13 characters.

Any suggestions on whats the best way to make this happen?

Thank You very much
 
I tried using both the LEN function to limit the characters and the LEFT function telling it to read only the "13" characters in this example. No matter what I write "ERROR" pops up which is supossed to appear only if the condition is not met.
 
Left("string ",13)

That is how I have set up the validation. Saying to leave 13 characters starting from the left.
 
Is this working for you now? If not, i'll check it in the morning - I don't recall the specifics of validation offhand.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
V How to use Comas in a picklist in Outlook forms Outlook VBA and Custom Forms 3
D Outlook 365 Custom forms field limit? Outlook VBA and Custom Forms 4
V Is it possible to collect statistics from Outlook forms? Outlook VBA and Custom Forms 1
V Outlook Forms: Formatting a Label with 2 different styles Outlook VBA and Custom Forms 1
N Outlook Forms Help Outlook VBA and Custom Forms 2
B Outlook Custom forms Using Outlook 0
N Export Outlook custom forms fields to excel Outlook VBA and Custom Forms 1
Diane Poremsky How to clean up Outlook's Forms Cache Using Outlook 0
Diane Poremsky Designing Custom Outlook Forms Using Outlook 0
G Outlook forms text input Outlook VBA and Custom Forms 1
J Outlook 2013 Forms Issue Using Outlook 1
N Outlook Forms Not Displaying Outlook VBA and Custom Forms 6
D Using Follup in Custom Forms Outlook 2013 Using Outlook 9
K Outlook Crash on referencing forms Using Outlook 1
M does outlook 2013/365 on mac support custom forms? Outlook VBA and Custom Forms 1
R Viewing & Using custom forms/tasks in Outlook 2013 Using Outlook 1
W Outlook 2010 Forms Using Outlook 1
G Questions on creating Outlook forms Using Outlook 0
O Outlook 2013 and Organizational Forms Library Using Outlook 2
M Outlook 2010 Forms Using Outlook 1
O Outlook 2003 forms problem Using Outlook 3
M Add custom locations to Outlook Forms "Look In:" drop-down list Using Outlook 5
J Update Outllook 2010 to Outlook 2013 - Incorrect Forms Using Outlook 2
M Workarounds for sharing custom Outlook 2007 forms? Using Outlook 3
J Outlook Forms 2010 Sent form will not open Using Outlook 1
P Outlook Forms??? Using Outlook 1
J Outlook 2010 Forms Help Needed "A field in this form requires a value." Using Outlook 6
P Unable to delete custom forms in outlook 2010 Using Outlook 1
O Outlook custom forms (2003) Using Outlook 5
G Outlook Forms Blank once sent. Using Outlook 1
A Outlook 2013 corrupting custom forms? Using Outlook 34
T Outlook 2007 forms: Check boxes and free text boxes not retaining data Using Outlook 1
N Creating dynamic forms in outlook?? Using Outlook 2
G Outlook 2007 Forms Compatibility Issues Using Outlook 0
J Outlook 2010 Editing Forms Using Outlook 3
S Outlook 2010: Cannot save forms templates to folder list Using Outlook 4
F can I use Outlook 2007 to create peer review/approve/reject forms Outlook VBA and Custom Forms 1
H Exporting Outlook Forms to Access or Excel Outlook VBA and Custom Forms 2
B Re: Outlook Forms E-mail Creation Sending Blank Fields Outlook VBA and Custom Forms 1
L Help using forms in Outlook Outlook VBA and Custom Forms 2
L Outlook 2003 Forms Outlook VBA and Custom Forms 1
F Outlook Calendar forms Outlook VBA and Custom Forms 2
B strange change in Outlook 2000 forms Outlook VBA and Custom Forms 1
J Customizing fields in Outlook forms Outlook VBA and Custom Forms 1
I Today function in Outlook Forms Outlook VBA and Custom Forms 1
A Outlook Forms Outlook VBA and Custom Forms 1
A Outlook Forms Outlook VBA and Custom Forms 1
A Outlook 2007 forms Outlook VBA and Custom Forms 1
B Are their other Outlook Journal entry forms besides the standard? Outlook VBA and Custom Forms 1
S Re: Capturing Outlook Forms Events Outlook VBA and Custom Forms 1

Similar threads

Back
Top