Export Project Tasks into Outlook

timwilliams77
timwilliams77 used Ask the Experts™
on
I have got Project 2007 and Outlook 2007
I need to import my tasks in to Outlook,
I have looked for a tool to do this but they are either trials or you have to buy them
Is it possible to create a macro to do this or does it have to be a manual export to excel?
i have got the following problems with using excel
1) It exports all tasks including headers, this is a problem because I want to only export sub tasks as the higher archey tasks are just headers, can this be done?
2) I have multiple headers with the same sub tasks but just for different areas, this causes a problem because I then have multiple tasks with the same name in outlook

Please see my attached MPP, please raname back to .mpp
Conv-OB.xls
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Here's a free add-in: unfortunately can't try it out on the customer's laptop, so either try it yourself or I'll have a try this evening when I get home.

http://www.projectviewercentral.com/projectviewer/outlook_project_connector.html

Author

Commented:
This is only a trial
Commented:
Export the tasks from the MS Project 2007 to the Excel.
Define the range of data to be imported to Outlook.

From the Outlook, Import the data (map the corresponding columns) and you can view the tasks in the Outlook tasks.

I have tried a sample and it is working.

thanks,

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial