Hi all

I have developed a new system which uses information from a number of different people's outlook calendars. At the moment I am having to go into each profile and manually export their calendars into an individual excel spreadsheet for each of them.

This works fine apart from the fact that there are now 75 people taking part in this system which means a lot of manual opening and closing of different people's mailboxes. I have set up a profile for each person on my computer, so what I need if possible is the following:

A macro that will go into a new person's profile and export their calendar to excel, then close the profile.

Does anyone have any starting points for me on this one. I believe I can work through the calendar export but I am struggling with the code for opening different profiles and closing them again.

Any help would be much appreciated.

Brokovich