Home | About Us | Feature | Programs | Support | Training | Development | Downloads | Free Tools | Newsletter | Links | Contact

Microsoft Outlook Tips and Tricks, and Code

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

 


Tip: Use BCC for Mass e-mails

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.

Tip: Save Typing, Look More Professional – Use Signatures (Nov 2008 Newsletter)

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.

Trick: Apply your Default Font

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.

Tip: Automatically Check Spelling

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?

January 2009 Tip: Organise your Microsoft Outlook into Folders

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.

February 2009 Tip: Organise your Microsoft Outlook with Rules

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.


Code: Check If You've Forgotten your Attachments

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

 

Code: The AdvancedSearch Method

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.

Code: Program to Transfer Outlook Addresses from e-mails to Maximizer

 
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.

 

Press Ctrl+F to search this page for keywords.


Do you want to remember this page?
| Back to top | ©2000-2011 Communication in Action cc t/a Software Africa. All rights reserved.  Updated 23 April 2011 e-mail Webmaster.