?
Solved

Add Outlook appointments from stored procedure

Posted on 2009-02-18
3
Medium Priority
?
1,881 Views
Last Modified: 2012-06-22
Hi,
We are using SQL 2005, Outlook 2003 and Exchange Server 2003.
I need to add appointments to individual users outlook calendars from within a SQL 2005 stored procedure based on a date and time entered into a database table.  I do not need to worry about scheduling conflicts.  It would be nice if I could remove the appointment from outlook if the record was deleted in the database, but I do not have to update the db if the user changes the appt in outlook ( at least not yet ).

Thanks!
0
Comment
Question by:Waterstone
  • 2
3 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 2000 total points
ID: 23678579
since you are using sql server 2005 you can use clr stored procedures and triggers
check this link
http://www.outlookcode.com/codedetail.aspx?id=775
for c# code to create appointment in outlook

all you need to do is create a clr trigger on that table that will run the above code after insert
you could try to implement the appointment removal using a delete trigger, but i don't know if you would be able to pull it of if the user had changed the date and time of the appointment
0
 

Author Comment

by:Waterstone
ID: 23686502
Thanks momi.  I will take a look at this next week and see if it will work with our exchange server.
0
 

Author Closing Comment

by:Waterstone
ID: 31548446
Sorry it took so long to close this.  Solution worked and we are all set.  Thanks!
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question