Group:  Microsoft Outlook ยป microsoft.public.outlook.program_addins
Thread: Automate export of Appointment Insert/Update/Delete infomation to the database

Geek News

Automate export of Appointment Insert/Update/Delete infomation to the database
cookiesncreamychoc[ at ]hotmail.com 3/14/2006 1:08:55 AM
Hi All,

I'm a newbie and have managed to create an add-in (VB 2005) that stores
all the appointment times against the contacts entered in the contacts
field of the appointment form (Outlook 2003) in a SQL 2000 database.

Is there a way to automate the updating of database on clicking the
save button for an appointment in the appointment form or moving the
appointment in the calendar?
I have found some (barely enuf) info about the AppointmentItem.Write
and MAPIFolder.Items.ItemAdd events but I'm not sure abt how to use
them.

Any help wud n appreciated.

Thanx

Re: Automate export of Appointment Insert/Update/Delete infomation to the database
cookiesncreamychoc[ at ]hotmail.com 3/14/2006 2:28:15 AM
I managed to fix this ...thanx anywayz guys...

But i just have another question with the ItemRemove event of the
calendar folder as the item is not passed as a parameter (unlike
ItemAdd and ItemChange events) I need to update a column in the
database. How do I retrieve the AppointmentItem in this instance??

Thanx

Re: Automate export of Appointment Insert/Update/Delete infomation to the database
cookiesncreamychoc[ at ]hotmail.com 3/14/2006 2:59:16 AM
I manged to get that one sorted too....
thanx ppl.... i must have Sue Mosher's thinking hat on ;) !!!

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net