Outlook Form Field Validation 1

[joelrob]

Trying to force users to include the job number in the subject of every e-mail that goes out. Anyone know a good tutorial for taking the string of the subject and searching for six integers inside that string?

Not looking for that specifically, but a good starting point. Most of the validation tutorials I've found have been incredibly basic.

TIA

 

[WinblowsME]

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
   Dim regex As Object
   Set regex = CreateObject("VBScript.RegExp")
   
   regex.Global = True
   regex.Pattern = "[0-9]{6}"
   
   If Not regex.Test(Item.subject) Then
      MsgBox "Include the job number in the subject line"
      Cancel = True
   End If
End Sub

 

[joelrob]

Just what I was looking for, thanks!