Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2001
    Location
    UT Medical Center
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exporting Calendar Events (Outlook 2000)

    Does anyone know of a script that can be ran on a client PC to export the events in an Outlook calendar by date range (e.g., 01/01/01 to 12/31/01) to an excel or access database?

    Thanks,

    Gary W. Haney

  2. #2
    Star Lounger
    Join Date
    Mar 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Calendar Events (Outlook 2000)

    Why don't you just use the import and export facility of Outlook itself. It will create an excel or access file for specified dates, with calendar infor in it.

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Albuquerque, New Mexico, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Calendar Events (Outlook 2000)

    This will indeed work EXCEPT if your calendar contains recurring appointments/meetings, the recurring items won't export correctly - you don't get ALL of the appointments. For example, I have a weekly meeting that is set up as "recurring". When I export, only ONE appointment is exported (the first one I created). If I need the other dates in my access table, I have to manually enter them. Microsoft knows that this is a problem. Additionally, Outlook will NOT export required attendees. Yes, Microsoft knows about the bug. That bug existed in Outlook 98 and I had hoped it would be fixed in 2000 but NOT!

    As far as programmatically exporting items to Access, look up Article ID: Q253794 in the Microsoft Knowledge Base.

    I hope this helps. <img src=/S/angel.gif border=0 alt=angel width=15 height=21>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •