Add Outlook appointments from stored procedure

Posted on 2009-02-18
Last Modified: 2012-06-22
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 ).

Question by:Waterstone
    LVL 37

    Accepted Solution

    since you are using sql server 2005 you can use clr stored procedures and triggers
    check this link
    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

    Author Comment

    Thanks momi.  I will take a look at this next week and see if it will work with our exchange server.

    Author Closing Comment

    Sorry it took so long to close this.  Solution worked and we are all set.  Thanks!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now