Book Image

The Microsoft Outlook Ideas Book

By : Barbara March
Book Image

The Microsoft Outlook Ideas Book

By: Barbara March

Overview of this book

Microsoft Outlook, in tandem with Microsoft Exchange Server, provides a powerful environment for sharing information. This book will show you how to take advantage of that to construct solutions for your business or organization from the features of Outlook. This book is a collection of scenarios that incorporate and link many Outlook components to produce surprisingly powerful functionality. Without the need for code or specially-written applications, you will be extracting information from your Outlook Calendar, Contacts and Tasks folders to create solutions like these: Monitoring staff leave and printing schedules Managing meeting rooms and printing invoices Managing fleet vehicles, their records, and servicing Managing a school class calendar, student records, attendance, assignments, and reports
Table of Contents (8 chapters)

Number of Days Left to Complete a Task


A useful new field for all of these views is one that will calculate the numbers of days that remain to complete a task. The calculation relies upon the creator of the task stipulating a due date. Where no due date is set, #ERROR will appear in the field that we are about to create.

Creating the Task

  1. 1. Create a new field as follows:

Name

In the Formula Field window

Days Remaining

Int([Due Date]-Now()) & " day(s)"

  1. 2. In the View Summary dialog box, click Automatic Formatting and turn on the standard Overdue Tasks rule that will format in red font those tasks that have not been completed by the Due Date.

The Result

This is the Tasks assigned by me view including the Days Remaining field: