|
For other tips, why not subscribe to our free monthly
newsletter:
Subscribe now!
In most browsers, you can press Ctrl+F, or Edit >
Find, to search this page for keywords.
Contents:
Tip: Use BCC for Mass e-mails
Tip: Save Typing, Look More Professional – Use
Signatures
Trick: Apply your Default Font
Tip: Automatically Check Spelling
January 2009 Tip: Organise your Microsoft Outlook into Folders
February 2009 Tip: Organise your Microsoft Outlook with Rules
Code: Check If You've Forgotten your Attachments
("Attachment Nanny")
Code Tip: Searching Outlook Folders with
AdvancedSearch
Code Available: Transfer Outlook e-mail Addresses
from a batch of e-mails to Maximizer
We suggest you use BCC (Blind Carbon Copy) instead of CC when you
send out mass e-mails to many of your contacts. That way you
don't get everybody seeing everybody else's e-mail address (and
possibly using them for spamming purposes!).
If you have created your e-mail in Outlook and can't see the BCC
box, click View > BCC Field.
It looks professional if all your e-mails have your contact details at the
bottom. You can set Outlook to automatically fill in a "signature" for you at
the bottom of new e-mails, and a different (e.g. shorter) one for replies. In
fact it is a legal requirement that your company registration number appear on
all official correspondence. Some companies use it for their e-mail disclaimer,
too.
To set up signatures, use Outlook's Tools > Options > Mail Format
(tab) > Signatures.
You can use this for much more than just some automatic text at the foot of new
e-mails and replies: You can set up as many "signatures" as you like, and drop them into e-mails using
Insert > Signature. This is useful for any "boilerplate" text (text
that you use repetitively and don't want to retype). Examples: Your
signature in Afrikaans, Sotho or Zulu, directions to your offices, disclaimer
notice, favourite quotations, tip of the day.
In the Outlook e-mail editor, if you change a text e-mail to an
HTML e-mail (Format menu > HTML), Outlook in its wisdom changes the
e-mail font to Times New Roman even if all your settings (in Tools >
Options > Mail Format > Fonts) are Arial. Microsoft have
acknowledged this as a bug and may fix it sometime this millennium.
In the meanwhile, they suggest as a workaround that you select all
text (Ctrl+A) and then press Ctrl+spacebar, an undocumented shortcut
that will apply the default font to the text. You could also
use it on any selected text, instead of the whole document.
You can set Outlook to automatically check your spelling before
sending: Use Tools > Options > Spelling, the second option.
On the subject of spelling, the error I see most often is "its"
vs. "it's". Note:
It's = "It is" or "it has".
Its = belonging to it – no apostrophe!.
Here's how to remember it easily: You don't write Her's or Hi's, do
you?
Do you have an Inbox
containing 500+ items, many of them unread? (Including this newsletter?)
Here's a way to start getting organised for 2009. The principle is to
group things together in folders, using the same structure as you would use with
a physical filing system. You move items to these folders (leaving them
unread or re-marking as unread) and deal with them at the appropriate time.
You might create a folder
named "Customers" containing sub-folders for your regular customers, and use the
"Customers" folder for and customers that don't have sub-folders. I have
Inbox sub-folders for Company matters, Business enquiries, Microsoft, etc.
To create a new folder,
right-click on any folder in the tree view on the left of Outlook. From
the pop-up menu choose "New folder". Type the name; check below that the
new folder will be in the right place (if you right-clicked on the parent folder
it will already be correct). Click OK.
In the next tip we will see how
to use Rules to automatically move inbound items to the correct folders.
In the last
tip we
suggested that you organise your Inbox using sub-folders to mimic your physical filing system.
We talked about how to create these folders. Now we will set up Rules to automatically move inbound items to the correct folders.
Click Tools > Rules and
Alerts. Click the button New Rule. The Rules Wizard pops
up. The radio button "start creating a rule from a template" is selected.
In the list below ("Step 1"), choose either "Move messages from someone to
a folder" or Move messages with specific words in the subject to a folder". In
Step 2 below, click on the underlined blue hyperlinks and fill in the data or
select the folder. Click Next > and make any changes or additions.
Click Next > for the actions, and Next > for any exceptions.
Give it a name, set it to run on existing items if you want, and click Finish.
The rule will appear in the list, where you can change the order of processing.
Finally, click OK to save.
Outlook can handle about
20 such rules before it starts ignoring them, so you might need to make some of
the less-frequent moves manually.
This program will alert you whenever you try to send an e-mail that has
no attachments, but has "file",
"attach", or "doc" in the body text, or "herewith" in the body or
the subject. It will pop up this message:

Hit No to stop the e-mail being sent, yes if you are
happy to send without attachments
To install it, do the following:
- Select (drag over) all the code below, and Copy it to the
Clipboard (Ctrl+C)
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
' For automated templates for your company, programming, or '
' other computer requirements including complete solutions: '
' Communication in Action (Pty) Ltd. t/a Software Africa '
' Tel Local: 011 802-2685, International: +27 11 802-2685. '
' Fax Local: 011 802-4576, International: +27 11 802-4576. '
' PO Box 987, Gallo Manor, 2052 South Africa. '
' Web site: www.softwareafrica.co.za '
' E-mail: info@softwareafrica.co.za '
' '
' Programmed by Rick Raubenheimer, MCSD: June 2006. '
' E-mail: rick@softwareafrica.co.za '
' '
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Option Explicit
Option Compare Text
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
' Revised: Simplified code, added Subject and "herewith". ' RIR 060623
' Created: ' RIR 060621
Const Ttl$ = "Software Africa's Attachment Nanny found No Attachments!"
Const Msg$ = "Have you attached all your attachments?"
Dim Ask As Boolean
If Item.Attachments.Count = 0 Then ' Only check if No Attachments
' Change or remove the "If InStr" lines below to suit your needs:
If InStr(Item.Subject, "herewith") Then Ask = True
If InStr(Item.Body, "herewith") Then Ask = True
If InStr(Item.Body, "attach") Then Ask = True
If InStr(Item.Body, "file") Then Ask = True
If InStr(Item.Body, "doc") Then Ask = True
If Ask = 0 Then Exit Sub
If vbNo = MsgBox(Msg$, vbYesNo + vbQuestion, Ttl$) Then Cancel = True
End If
End Sub
- In Microsoft Outlook (or even in an e-mail), press Alt+F11
- This will take you into Outlook's Visual Basic Editor
- You should see a "Project Explorer" on the left (if not, hit
Ctrl+ R)
- Click the plus buttons in the "Project Explorer" to expand
down to
- + Project1
- +-- Microsoft Office Outlook
- +---- ThisOutlookSession
- Double-click "ThisOutlookSession": You should get a white
window pane on the right, with just "Option
Explicit" in it, or it may be blank.
- Select (drag over) "Option Explicit" (if
it's not there, just click in the blank pane)
- Paste from the Clipboard (Ctrl+V)
- Click (menu) Debug > Compile Project1 (there should be no
errors: If there are, contact us!)
- Click the "Save" icon (diskette) or File > Save
VBAProject.OTM
- Close Outlook Visual Basic.
- In Outlook, click Tools > Macro Security and select
Medium
(it may be set High by default and then the macros won't
run)
- When you start Outlook, you will get the message:

- Click Enable Macros (you can avoid this by selecting Low
Macro Security –not recommended!).
Test by
creating an e-mail with "file", "attach", or "doc" in the body,
or "herewith" in the body or the subject.,
and clicking "Send".
One Drawback: If you're replying to a message that had one of
those words in it, it will ask about the attachment even if it's not
mentioned in your reply. Better safe than sorry!
There's a bug (or feature!): If you include a picture in
your e-mail, it is counted as an attachment!
PS: Feel free to share this code as long as it remains intact
including the attribution at the top or, better still,
click here to e-mail your contacts a link to this web page.
Performs a search through specified Outlook folders based on
a Microsoft SQL Server search string and returns a
Search object. For tons of useful information on the
subject, look in Outlook's Visual Basic Help for
"AdvancedSearch". This seems to be only in Outlook 2002
and later.
The program
works as follows:
-
You must
have Maximizer running.
-
You then run
the Outlook macro and it will scan a specific Outlook
folder.
-
Each e-mail
in the folder will be processed and it will search Maximizer
for the sender's e-mail address (in "e-mail Address 1").
-
If it does
not find that address in Maximizer it will create a new
Individual Contact with that e-mail address.
-
It also does
its best to work out the name of the sender, their
telephone, fax, and cell numbers, but these may be
inaccurate or non-existent depending on what is in the
e-mail.
-
The program
inserts a note into Maximizer containing the e-mail, with a
header saying that it either found or added the contact.
This code is not free, but is
available from us for a nominal charge. Installation is
similar to that for the Attachment Nanny above.
Enquire Here.
Contributed Tips
Would you like to add a tip of your own (due acknowledgement will be
given!) –
click here.
|