Linking from Excel to public outlook 2010 calendar.


I have a number of public email folders representing "projects" for my employer. I also have an excel spreadsheet which summarises all projects. This spreadsheet, among other things, has "week1", "week2", "week3" columns, where we put the anticipated events occuring in each week.

I'd like to have a "calendar" for each project stored in its public folder, with a simply hyperlink in the excel spreadsheet linking to it.

Of course in an ideal world, I'd love some way of showing the data from the calendar in excel, but one step at a time. A simple column of hyperlinks, one for each project (spreadsheet row) will be sufficient for now.



Similar threads