Thursday, February 16, 2012

Integrating Project 2010 with Outlook

Adding Outlook Tasks to Your Project Plan
Suppose you started brainstorming tasks for a new project in your Outlook Tasks list, and you’re now ready to import those tasks into Project 2010.

To import Outlook tasks into your project plan, follow these steps:
1. In Project 2010, open the project plan into which you want to import the Outlook tasks.
2. On the Task tab, in the Insert group, click the down arrow below the Task button, and then click Import Outlook Tasks.
3. If a security alert appears, click Allow.
As long as at least one incomplete task is present in your Outlook Tasks list, the Import
Outlook Tasks dialog box appears, even if Outlook is not already running any tasks marked complete in Outlook are not listed in the dialog box.


4. Select the check box for each task you want to import. Click the Select All button to import all listed tasks.
Items displayed with a darker background are folders or summary tasks, and you might not want to import them. If the same tasks are saved in multiple folders, be careful to select just one instance of the task for import. Clear the check box for any Outlook tasks not relevant to your project plan.
5. After selecting the tasks you want, click OK.
The tasks you selected are appended after the last task in your project plan.

The imported Outlook tasks have the following characteristics:
● If the task mode for new tasks is set to Manually Scheduled, the tasks are created as manually scheduled tasks, and durations from the Outlook tasks are copied to the Project 2010 Duration field. The Start field for these tasks remains empty.
● If the task mode for new tasks is set to Auto Scheduled, the tasks are created as automatically scheduled tasks, and durations entered in Outlook are not copied to Project
2010. The imported Outlook tasks revert to the default estimated duration of 1 day.
The start dates of the imported tasks are set to the project start date with the ASAP constraint.
● There are no links, predecessors, or assigned resources.
● Any notes entered in Outlook become task notes. Double-click the Note indicator in the Indicators column to review the note.

Adding Project 2010 Tasks to Outlook Tasks
Adding Outlook tasks to your project plan can help you quickly create tasks necessary to your project. Going the other direction—that is, adding key project tasks from your project plan to your Outlook Tasks list—is helpful when you want to keep a closer eye on critical tasks or milestone tasks, for example. Adding project tasks to your Outlook Tasks list is also helpful when you want to monitor tasks that you’re assigned to.
In Project 2010, you can send several tasks and some of their associated information to your Outlook Tasks list by using the Set Reminder command. However, this command is not on the ribbon by default.
If you plan to frequently add Project 2010 tasks to your Outlook Tasks list, add the Set Reminder command to the Quick Access Toolbar. To do this, follow these steps:
1. Click the arrow next to the Quick Access Toolbar, and then click More Commands.
2. In the Choose Commands From box, click Commands Not In the Ribbon.
3. Click Set Reminder, and then click the Add button.
4. Click OK.
The Set Reminder button is added to the Quick Access Toolbar.

Now that the Set Reminder button is on the Quick Access Toolbar, you can send Project 2010 tasks to your Outlook Tasks list by following these steps:
1. Open the project plan that contains the tasks you want to track in Outlook.
2. Select the tasks you want to send to Outlook.
Drag to select multiple adjacent tasks, or hold down the Ctrl key to select multiple nonadjacent tasks.
3. On the Quick Access Toolbar, click Set Reminder.
4. Specify when you want the reminder to alert you. You can set the reminder for a number of minutes, hours, days, or another period of time before the start or finish date of the selected tasks.
5. Click OK.
The selected tasks are added to your Tasks list in Outlook. The start date, reminder time, and due date (finish date) are included.


Another way to add project tasks to Outlook is to use the Copy and Paste commands. However, you can copy only the task name, and you have to copy the tasks one at a time.
To copy and paste a task name to your Outlook task list, follow these steps:
1. In your project plan, display a task view such as the Gantt Chart.
2. Select the name of the task you want to copy to Outlook.
You can copy and paste only one task at a time from your project plan to Outlook.
Be sure to select only the task name. If you select multiple fields, all the information is pasted together in the task’s Subject field in Outlook.
3. On the Task tab, in the Clipboard group, click Copy.
4. Switch to Outlook and display the Tasks view or the To-Do list.
5. Right-click in the Subject entry box labeled Click Here to add A New Task, and then click Paste.
The task you copied from your project plan appears in the box.
6. Press Enter.
The task is added to the Tasks list.
7. Repeat steps 2 through 6 for any additional tasks you want to copy to Outlook.

Copy Tasks To and From Outlook E-mail Messages Suppose you ask team leads to identify tasks for their portions of your project. They send you e-mail messages with the tasks they identified listed in the body of the message.
When you use Project 2010 and Outlook 2010, you can copy these tasks to your Project 2010 file simply by copying the text of the message and pasting it into the Task Name column of a Project 2010 table.
In the opposite direction, you can paste Project 2010 task information into an Outlook e-mail message. The information that you copy is automatically pasted as a table with the headings from the Project 2010 table in the first row. The Project 2010 table data that you paste into an Outlook e-mail message also retains the formatting you applied in Project 2010.

Monday, January 2, 2012

Inactive Tasks - Microsoft Project 2010







I've found this new feature useful when reassessing the critical path and considering changes to a project schedule. Instead of saving different versions as I examine what-if scenarios, I can inactivate and back out the changes as necessary.



The inactive tasks feature allows project managers to remove tasks from the schedule while recognizing the task existed in the original plan.

To set a task to an inactive status:


1. Click on the task.

2. In the Task ribbon, in the Schedule section, click on the Inactivate icon.

3. The task will appear grayed out with a strike-through line.



When a task is inactivated, the task and its associated budget, work and assigned resources are not included in the schedule calculations. This feature also allows you to do some what-if analysis when assessing a potential change to your project schedule without losing the original schedule data. Inactivating a task is easy however there are several considerations when inactivating a task.

Sunday, December 25, 2011

Microsoft Project History

Microsoft Project History
The first commercial version of Project was released for DOS in 1984. Microsoft bought all rights to the software in 1985 and released version 2. Version 3 for DOS was released in 1986. Version 4 for DOS was the final DOS version, released in 1986. The first Windows version was released in 1990, and was labeled version 1 for Windows.
In 1991 a Macintosh version was released. Development continued until Microsoft Project 4.0 for Mac in 1993. In 1994, Microsoft stopped development of most of its Mac applications and did not offer a new version of Office until 1998, after the creation of the new Microsoft Macintosh Business Unit the year prior. The Mac Business Unit never released an updated version of Project, and the last version does not run natively on Mac OS X.
Microsoft Project 95 was the first to use common Office menus.
Microsoft Project 98 was the first to use Tahoma font in the menu bars and to contain Office Assistant, like all Office 97 applications. Project 98 SR-1 was a major service release addressing several issues in Project 98. Versions were released in 1992 (v3), 1993 (v4), 1995 (4.1a), 1998 (9.0), 2000 (10.0), 2002 (11.0), 2003 (12.0), 2007 (13.0) and 2010 (14.0). There was no Version 2 on the Windows platform; the original design spec was augmented with the addition of macro capabilities and the extra work required to support a macro language pushed the development schedule out to early 1992 (Version 3).

Microsoft Office Package

Microsoft Office Package













Tuesday, December 20, 2011

How to send a column information from MS Excel 2010 to Text file format with (;) separator?



1- You must to convert the column data to row data by using copy and paste transpose from the paste options in the Excel 2010.
2- Delete the column data and keep the row.
3- Save the Excel file as CSV (Comma delimited) or Text tab delimited.

Monday, December 19, 2011

Roll Up the Custom Field in the MS Project Professional 2010



By default, Project 2010 does not calculate values for custom fields for summary tasks or for the rows containing rolled-up values for groups. However, you can choose the type of calculation for summary tasks and group summary rows or use the formula you defined for the field.
If you select the Rollup option, you can choose from several built-in calculations in the
Roll-up drop-down list, including the following:
● Average The average of all nonsummary values underneath the summary task or group
● Average First Sublevel The average of all the values of tasks one level below
● Maximum The largest value of all nonsummary values
● Minimum The smallest value for all nonsummary values
● Sum The sum of all nonsummary values underneath the summary task or group
To do this:
1. Open the custom fields dialog box by right click any field header and click custom fields.
2. Create your custom field and give it a name.
3. Click the roll up option.