A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Add-ins for Outlook
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

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



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old March 14th 06, 02:08 AM posted to microsoft.public.outlook.program_addins
[email protected]
external usenet poster
 
Posts: 17
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

Ads
  #2  
Old March 14th 06, 03:28 AM posted to microsoft.public.outlook.program_addins
[email protected]
external usenet poster
 
Posts: 17
Default 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

  #3  
Old March 14th 06, 03:59 AM posted to microsoft.public.outlook.program_addins
[email protected]
external usenet poster
 
Posts: 17
Default 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 !!!

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I export appointment labels in outlook srp Outlook - Calandaring 1 March 10th 06 04:50 PM
How do I delete a reminder - appointment has already been deleted Compassion Outlook - Using Forms 0 March 4th 06 06:34 PM
my outlook calender has stopped allowing me to insert appointment speed777 Outlook - Calandaring 1 February 11th 06 11:01 PM
Can't delete private appointment on public calendar Sue Mosher [MVP-Outlook] Outlook - Calandaring 2 January 20th 06 12:43 AM
Outlook - delete a reoccurring appointment, from "this point on" haveaniceday Outlook - Calandaring 2 January 17th 06 08:03 PM


All times are GMT +1. The time now is 09:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.