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.

 

cocolete

Member
Outlook version
Email Account
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
 

cocolete

Member
Outlook version
Email Account
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
 

cocolete

Member
Outlook version
Email Account
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.
 

cocolete

Member
Outlook version
Email Account
Left("string ",13)

That is how I have set up the validation. Saying to leave 13 characters starting from the left.
 

Forum Admin

Senior Member
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

Top