RSS Feed Available
Tip 225: Can't Connect to Exch Server?
Tip 226: Manage Read Receipt Requests
Tip 227: Identify Canceled Meetings
Tip 228: Keep Search Folders Searching
Tip 229: Copy the Outlook Bar
Tip 230: OL doesn't remove Re: Re:
Tip 231: Preview Draft Messages
Tip 232: Color Messages Using Rules
Tip 233: Advanced Find
Tip 234: Windows Shortcuts
Tip 235: Calendar Shortcuts
Tip 236: Multiple Outlook Calendars
Tip 237: Countdown Appointments
Tip 238: Clipboard Clears
Tip 239: Folder Names are Cut Off
Tip 240: Archive OWA Using Outlook
Tip 241: Outlook's HTTP Protocol
Tip 242: Mail Merge Categories
Tip 243: Permanently Deleting Items
Tip 244: Backup BCM databases
Tip 245: Outlook2003 Desktop Alerts
Tip 246: Custom Voting Buttons
Tip 247: Printing emails
Tip 248: Disable Antivirus Scanning
Tip 249: More Antivirus Comments
Tip 250: Viewing Long Folder Names
Tip 251: Outlook2003 Autosignature
Tip 252: Using a PST Stored on a CD
Tip 253: Identifying QuickFlags
Tip 254: Copying Lists
Tip 255: Enabling Disabled Items
Tip 256: Using F11 and Add-ins
Tip 257: Share Messenger Contacts
Tip 258: Can't Attach Zips
Tip 270: Display Navigation Calendars
Tip 259: Calendar Display Looks Wrong
Tip 260: All Day Event Reminders
Tip 261: Autoformatting Limits
Tip 262: Exchange Server 2003 SP2
Tip 263: WinXP Unread Message Count
Tip 264: Email Won't Send
Tip 265: Business Contact Manager v2
Tip 266: Reply in Different Colors
Tip 267: Troubleshooting Steps
Tip 268: Storing Documents in Outlook
Tip 269: Spell Check Plain Text Replies
Tip 271: Print Part of a Message
Tip 272: Creating Custom Searches
Tip 273: Add Folders to Favorite Folders
Tip 274: Change Open or Save Options
Tip 275: Blocking Email Addresses
Tip 276: Display Inline Images
Tip 277: Automatically Send & Receive
Tip 278: Filter Blank Senders
Tip 279: Exchange Extensions Errors
Tip 280: Resolving Addresses
Tip 281: Recurrence Pattern Filter
Tip 282: Display Calendar Names
Tip 283: Booklet Printing Hotfix
Tip 284: OL2003 Calendar Order
Tip 285: Read Only Attachments
Tip 286: Address Book Sort Order
Tip 287: Spouse & Children's Birthdays
Tip 288: Using the Activities tab
Tip 289: Activities & Advanced Find
Tip 290: Flags and Reminders
Tip 291: Outlook's Missing Holidays
Tip 292: Disable COM Add-ins
Tip 293: Hyperlinks Not Working?
Tip 294: Create an Accounts Toolbar
Tip 295: Get a Free Digital ID
Tip 296: Print Notes on a New Page
Tip 297: Drag & Drop to Create Items
Tip 298: Convert Plain Text to HTML
Tip 299: Repling to Multiple Addresses
Tip 300: Save Time Using Templates
Tip 301: Printing Just One Page
 


Create Countdown Appointments

Do you want to countdown the days (or weeks) until vacation? Do you want to know someone's age on their birthday?

Outlook doesn't support either option, but with a little help from Excel, you can easily create appointments that read "1 day until vacation", 2 days until vacation" or "Jack is 41", "Jack is 42".

The short version:

  1. Create a spread sheet with Start Date and Subject columns. (You might also want to use Categories)
  2. Enter the first date in the series. If it's today, press Ctrl+; (semi colon) for today's date.
  3. Select the cell and drag down until you reach the last date you need in your series.
  4. To countdown, go to the last date cell and enter the subject in the subject column, beginning or ending the subject with a number:
1 Day until vacation
Days until vacation: 1
  1. Either enter the subject for the date above it, using the next number in the series, or drag the subject cell up one and change the number to the next number in the series.
  2. Select both cells and drag up.
  3. If you are using a category, enter it and drag to fill.
  4. Select all used cells and type a name in the named range box above column A.
  5. Save and close the workbook.
  6. Import into Outlook.

If you need detailed steps and screenshots, see http://www.outlook-tips.net/howto/countdown.htm