aarontassell
New member
- Local time
- Today, 04:22
- Joined
- Jan 5, 2017
- Messages
- 2
I am trying to create a validation rule that will require the 1st 10 characters of a subject line in outlook to be formatted in the following format:
1st two characters are numbers, 3rd character a hyphen characters 4-7 numbers, 8th character hyphen, last two characters numbers Example (10-2356-00)
I found the validation rule below but not sure how to modify line 4 to accomplish my need. Any assistance would be greatly appreciated.
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim strSubject As String
strSubject = Item.Subject
If Len(Trim(strSubject)) >99-9999-99aaaaaa;;_
Prompt$ = "Reminder. Are you sure you added the job number?"
If MsgBox(Prompt$, vbYesNo + vbQuestion + _
vbMsgBoxSetForeground, "Check for Subject") = vbNo Then
Cancel = True
End If
End If
End Sub
1st two characters are numbers, 3rd character a hyphen characters 4-7 numbers, 8th character hyphen, last two characters numbers Example (10-2356-00)
I found the validation rule below but not sure how to modify line 4 to accomplish my need. Any assistance would be greatly appreciated.
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim strSubject As String
strSubject = Item.Subject
If Len(Trim(strSubject)) >99-9999-99aaaaaa;;_
Prompt$ = "Reminder. Are you sure you added the job number?"
If MsgBox(Prompt$, vbYesNo + vbQuestion + _
vbMsgBoxSetForeground, "Check for Subject") = vbNo Then
Cancel = True
End If
End If
End Sub