sql server linking to exchange personal calender files
Posted on 2003-12-04
I want to link to some outlook calenders (that have shares set up) to sql server, so i can get meetings and who is going to them into tabular form into a database, i'm happy enough with xp_send read mail and T_SQL but is there a way of getting a certain user's( a PA) meetings and the invitees into sql server.
I have admin access to a sql server box with smtp mail server set up and can link to the exchange server via Access 2000, but
I will up the points for a good technical answer but i anticipate the answer will involve buying propietry software or a link to a kb article.