Error proofing

E

Error proofing

When I type an incorrect date (e.g 31/04/2008) is it possible for outlook to
alert before sending.
 
E

Error proofing

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.
 
D

Duncan McC

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.

I think you're asking a bit much. The best way to ensure dates are
correct is to use an "insert date" function (as in MS Word).

Some questions back to you:

Is this a date? "tomorrow" - or is it a word? How would you know?

Is this a date: "next wednesday"

Is this a date: 20/12/08
Is this a date: 12/20/08
Is this a date: 08/12/20

You see, I could say they are all dates - because they are, I could even
say that "in ten minutes time" is a date (ok, a 'datetime' - but in
context of my post, it's a date (the post is dated, so "in ten minutes
time is a time on that date)).

This is fun :)
 
V

VanguardLH

in message
When I type an incorrect date (e.g 31/04/2008) is it possible for
outlook to
alert before sending.


How would a spell checker know that some substring within your
document represented a date? You are using a free-form input field,
not some formatted cells in a spreadsheet. It is up to you to review
your message BEFORE sending it. Besides a wrong date, a spell
checker, even if it has a grammar checker, cannot ensure either
accuracy in grammar or artistic license in getting a point across.
You are the author. It's your responsibility. Don't just dash out a
message and click Send. Read it before sending it; i.e., preview
before send. Sometimes our fingers don't type what we intended them
to type.
 
E

Error proofing

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.

If I type 'tiem' instead of 'time' the spell check says 'Not in dictionary'
why cant I make it say' '30/02/2008' is not in dictionary. These are the
dates which does not exist at all 30/02/2008, 31/04/2008, 31/06/2008,
31/09/2008,31/11/2008 as there are only 30 days in these months. Like I can
add any word to the outlook dictionary and ask it not to highlight as an
error next time, I want to add some words and ask it to alert if they are
part of my mail. I do read my mail before sending, but when I give my client
at payment date as 31/04/2008, in a hurry I forget that such a date does not
exist. sometime emails are an evidence in a leal suit and such mistakes are
costly.
 
D

Duncan McC

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.

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.
 
E

Error proofing

Thank you Duncan !

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.
 
Top