Exchange Synchronisation

Question

Good Morning! I'm currently working on a project to merge the appointments of our companies employees with a public calendar. I found some tutorials and code snippets showing the use of CDO to access Exchange mailboxes. So i managed to list all the exchange accounts out of active directory and connect to the exchange server. But i don't have any ideas on how to work with the ADODB queries... What i wanna do is: Open the calendar of a mailbox, iterate through all the appointments from date x to date y and create a corresponding appointment in the public calendar. Any help, suggestions or example on this would be highly appreciated ;) Robert

Robert Drescher · Answer

a little update, since no-one was interested in this... So far, my program does the following: - Get all email addresses out of the active directory - connect to each mailbox separately, looking for calendars. Here, i'm iterating throught the records children, until a calendar is found. - Iterating through the appointments of each calendar For debugging use, i output the fields of each appointment to a logfile. - Separately, another connection to a public calendar is established - Here, a recursive algorithm checks if the record is a calendarfolder. If it is, it returns his children, the appointments If not, it iterates through his children, calling itself for each record found. So obviously, in the end i should have a field in publicConnection containing the public Appointments and a series of appointments from the mailbox calendars. But my algorithm to open the public calendar returns the calendar itself, not its appointments. private Recordset getPublicCal(object source) { Record publicRecord = new Record(); publicRecord.Open(source, connection, ConnectModeEnum.adModeReadWrite, RecordCreateOptionsEnum.adFailIfNotExists, RecordOpenOptionsEnum.adOpenSource, "", ""); IEnumerator fields = publicRecord.Fields.GetEnumerator(); while (fields.MoveNext()) { Field tmp = (Field)fields.Current; if (tmp.Name == "DAV:contentclass") { if (tmp.Value.ToString() == "urn:content-classes:calendarfolder") { //found calendarfolder return publicRecord.GetChildren(); } else { break; } } tmp = null; } //no calendarfolder //enumerate children Recordset rs = publicRecord.GetChildren(); while (!rs.EOF) { Recordset returned = getPublicCal(rs.DataSource); if (returned != null) { return returned; } rs.MoveNext(); } return null; } so calling getPublicCal("http://server/public/public/Calendar") should return the Recordset of this calendars children, but it returns the calendar record itself. Why? A little help would be great thank you Robert Drescher