Export Outlook calendar to csv

[kerlj001]

Hi all

I have a very basic au3 script that exports an Outlook calendar to csv using SEND keystrokes etc, but I'm sure there's a better way?

Cheers

Jody

(was posted to the NEW forum but seems to of been lost)

CODE

AutoItSetOption("WinTitleMatchMode", 3)

Run("C:\Program Files\Microsoft Office\OFFICE11\Outlook.exe")

WinWaitActive("The School Calendar - Microsoft Outlook")

; Now quit by pressing Alt-f and then x (File menu -> Exit)

Sleep(4000)

;FILE

Send("!f")

Sleep(2000)

;IMPORT

Send("t")

Sleep(2000)

;CHOOSE

Send("{HOME}")

Send("{ENTER}")

;TOP

Send("{HOME}")

Sleep(2000)

Send("{DOWN}")

Send("{ENTER}")

Sleep(2000)

;CHOOSE

Send("{HOME}")

Send("+")

Send("{END}")

Sleep(2000)

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{UP}")

Send("{ENTER}")

Sleep(2000)

Send("!N")

Sleep(2000)

Send("{ENTER}")

Sleep(2000)

Send("{ENTER}")

Sleep(2000)

Send("01/08/2007")

Sleep(2000)

Send("{TAB}")

Send("30/08/2010")

Send("{ENTER}")

Send("!{F4}")

Edited July 5, 2009 by kerlj001

[water]

There's an Outlook.udf available from this forum.

Maybe it has the functions you need.

Edited July 6, 2009 by water