Hi! We use the outlook calendar to register our work hours in some proyects. We need to create a new event in the calendar witch ask us to send data to sql server. Example: Togay i worked from 9 to 13 in one proyect. I go to outlook and I created a new calendar note from 9 to 13 and i write a proyect name in the subject and save it. how can i send this data to a sql server or create a new form? we want to save this data in some SQL server tables: -begining date and hour - finishing date and hour - subject is posible to do it? the ideal way for that is maybe when we close the schedule window or so... can someone help us? thanks!!
What version of Outlook are you using? You can use the item.Write() event for items saved when they are opened. Open items are displayed in an Inspector and you can handle the Inspectors.NewInspector() event to see when something is opened. You can then get the item in the Inspector (Inspector.CurrentItem) and subscribe to its Write() event. For items changed from the folder view (Explorer) you would use ActiveExplorer.Selection to get the selected items and use the SelectionChange() event to handle changes in selection. You can then check to see if ActiveExplorer.CurrentFolder is a calendar type folder and if so set up item event handlers for Write() for all selected items in the calendar folder. When Write() fires you can then get the properties you want from the item such as Start, End, Subject, etc. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "iKER-" wrote in message news:4f904785-31e5-46e2-a618-38c09a1e3ae8@27g2000hsf.googlegroups.com... > Hi! > > We use the outlook calendar to register our work hours in some > proyects. We need to create a new event in the calendar witch ask us > to send data to sql server. Example: > > Togay i worked from 9 to 13 in one proyect. I go to outlook and I > created a new calendar note from 9 to 13 and i write a proyect name in > the subject and save it. > > how can i send this data to a sql server or create a new form? we want > to save this data in some SQL server tables: > -begining date and hour > - finishing date and hour > - subject > > is posible to do it? the ideal way for that is maybe when we close the > schedule window or so... can someone help us? > > thanks!!
