Just want to know if this is possible and if so how can it be done......
Lets say you have 3 columns in excel.
Start date; End Date; Project name.
Can the information in these columns be imported into outlook calendar so an appointment can be setup for the duration.
start date = 3/1/10
end date = 4/1/10
Project name = test project
An appointment would be set up in outlook calender from 3/1 - 4/1 with test project as the subject line. The ultimate goal is to take a project dashboard sheet that has multiple projects (1 per row) and produce a schedule of projects in a shared calendar.