PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook Program Addins Automate export of Appointment Insert/Update/Delete infomation to the database

Reply

Automate export of Appointment Insert/Update/Delete infomation to the database

 
Thread Tools Rate Thread
Old 14-03-2006, 01:08 AM   #1
cookiesncreamychoc@hotmail.com
Guest
 
Posts: n/a
Default Automate export of Appointment Insert/Update/Delete infomation to the database


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

  Reply With Quote
Old 14-03-2006, 02:28 AM   #2
cookiesncreamychoc@hotmail.com
Guest
 
Posts: n/a
Default Re: Automate export of Appointment Insert/Update/Delete infomation to the database

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

  Reply With Quote
Old 14-03-2006, 02:59 AM   #3
cookiesncreamychoc@hotmail.com
Guest
 
Posts: n/a
Default Re: Automate export of Appointment Insert/Update/Delete infomation to the database

I manged to get that one sorted too....
thanx ppl.... i must have Sue Mosher's thinking hat on !!!

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off