E
Error proofing
When I type an incorrect date (e.g 31/04/2008) is it possible for outlook to
alert before sending.
alert before sending.
How to make spell check catch hold of incorrect dates. Like as add words to
the dictionary, can words be added to be highlighed as error. I came accross
a program, which alerts if a mail is sent without a subject. Is a similar
kind of alter possible to incorrect dates of anything which I dont want to be
sent in my email.
When I type an incorrect date (e.g 31/04/2008) is it possible for
outlook to
alert before sending.
The program below when copied to the visual basic editor in outlook alerts
when a mail is send without a subject.
1. Open your outlook
2. Press Alt+F11. This opens the Visual Basic editor and then Press Ctrl+R
which in turn open Project-Project 1 (left side)
3. On the Left Pane, one can see "Microsoft Outlook Objects" or "Project1",
expand this. Now one can see the "ThisOutLookSession".
4. Double click on "ThisOutLookSession". It will open up a code pane.
5. Copy and Paste the following code in the right pane. (Code Pane) and save
it
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim strSubject As String
strSubject = Item.Subject
If Len(Trim(strSubject)) = 0 Then
Prompt$ = " Subject missing do you want to send a non professional mail ?"
If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for
Subject") = vbNo Then
Cancel = True
End If
End If
End Sub
Press alt+Q to close the visual basic screen.
Can a similar thing be done to add any word which I dont want to be part of
my email. I will check before sending my mail, but my team sometimes in a
hurry are not able to check.
Duncan McC said:Well... if you want to give that a go, then do so.
Dunno if you can mod the above and have an Item.Body
Do a search (perhaps in a case statement) for all your dates you want to
trap, using instr() (inString)?
That's just off the top of my head - check your VBA, I'm fairly rusty on
it.