Hi Gary,
Sure thing.
One option is the VBA option. I am *not* a VBA person, so what I can do is
direct you to a post by Maurice Birchler from May of 2005 that gives the VBA
code. That code can be found at the url listed below from Google Groups:
http://tinyurl.com/btn3h
I cannot provide assistance with the macro code and as Maurice notes in the
information he posted, you would need to change all references to "Maurice"
in the code to your name.
If VBA is not your strong suit and if you want a more manual approach you
can accomplish pulling task name, start date, and finish date and mapping
it to Outlook calendar fields to create calendar entries for the tasks.
The steps below are using Project 2003 , Excel 2002, and Outlook 2002, so
you may need to make some modifications if you are not using those releases,
but it should be very close.
From Project:
1) Make sure your date format shows date and time. (Tools > Options, View
tab.)
2) File > Save As to display the Save As dialog box.
3) Change the Save as type to CSV (Comma delimited)
4) Name the export file and select a location and click the Save button.
This will start the Export Wizard.
5) In the Export Wizard dialog box, click the Next button to proceed to step
2 (Export - Map) of the Export Wizard.
6) Select New map in the Export Wizard and click the Next button.
7) In the Export Wizard - Map Options, select Tasks, Export includes
headers, and leave the Text delimiter at comma. Click the Next button.
8) In the Export Wizard - Task Mapping, select Export filter of: "Using
Resource..." The filter will prompt for which resource's tasks you wish to
export.
9) In the From: Microsoft Office Project Field (first row) select: Name.
10) Click in the To: Text File Field in the same row and it should say Name.
11) In the second row under From: select Start.
12) Click in the To: field and it should populate with Start_Date
13) In the third row under From: select Finish.
14) Click in the To: field and it should populate with Finish_Date.
15) Click the Next button.
16) In the Export Wizard - End of Map Definition click Save Map.
17) In the Save Map dialog box, give the map a name and click the Save
button.
18) In the Export Wizard - End of Map Definition dialog box. Click Finish to
run the Using Resource filter.
19) Select the resource whose tasks you wish to export and click the OK
button to export the tasks to the CSV file.
In Excel:
1) Open the CSV file.
2) In a column immediately adjacent to the existing data enter Start_Time in
the first row.
3) Copy the Start_Date data and paste into the Start_Time column.
4) Repeat steps 2 & 3 to title the column Finish_Time and copy the data from
the Finish_Date column.
5) Format the Start_Date data as date only.
6) Format the Start_Time data as time only.
7) Repeat steps 5 & 6 to format the Finish_Date as date only and the
Finish_Time as time only.
8) Save the Excel file but choose to keep the existing format (*.csv)
9) Close the file.
In Outlook:
1) Choose File > Import and Export to open the Import and Export Wizard.
2) Choose Import from another program or file and click Next.
3) Choose Comma Separate Values (Windows) and click Next.
4) Browse to find the CSV file and select whether to replace duplicates,
allow duplicates, or not allow duplicates and click Next.
5) Select the Calendar as the destination folder and click Next to open the
Import a File dialog box.
6) Click in the check box next to Import "yourfilename" into folder:
Calendar and click the Map Custom fields button to open the Map Custom
fields dialog box.
7) Drag the word "Name" from the left side over the word "Subject" on the
right.
8) Drag Start_Date over Start Date.
9) Drag Finish_Date over End Date.
10) Drag Start_Time over Start Time.
11) Drag Finish_Time over End Time.
12) Click OK to close the Map Custom fields dialog box and return to the
Import a File dialog box.
13) Click Finish to import the CSV data into appointments in Outlook.
Have a drink ;-)
I hope this helps. Let us know how you get along.
Julie
