Read Outlook Data from VBS script

[Zxian]

Hey everyone,

I'm not sure if this should go here or in the Software Discussion section. If it's in the wrong place, Mods, please move it.

I'm trying to create a script that will allow me to read an Outlook data file and read the calendar data from it. Does anyone know how this can be done? I need the script written in VBS and not bat/cmd since I'll be using it with AveDesk (which only accepts VBS scripts) to read my Outlook calendar data and display it on my desktop.

Thanks in advance.

[army20]

ur not asking something very simple

[purewaveform]

Correct, that is a heafty task, and not something very easy. If you really want to accomplish this then here is a place to start http://www.vb123.com/toolshed/03_docs/outlookorders.htm the article is about processing email orders, but it will give you the gist on how to import the data, and how to parse it. Also, it would probably be a lot easier to just export the data manually, or you can modify the code that I have attached below. It was written by helen feddema and allow you to export the outlook data to an excell sheet. Then just write the vbscript to talk to excell, there are lots of tutorials on that on the web. Then the outlook to excel dump, just make that some cron so that the data dets exported every hour of somehting etc.

Good Luck.

code58.zip

[Zxian]

Nuts... It seems like for the Excel method to work, I need to manually update the data...

There's a plugin for Rainlendar that reads this data, but that's written in C++. Maybe I'll look into the plugin and the link you provided and try to combine the two to get what I'm after...

Thanks for the info.

[purewaveform]

look for the excell sheet, just write a vb ssript that will open and send the commands to do the update, then put that script in the cron so that it updates the data every so often, lot easier than trying to integrate something else.