Outlook Schedule Export Automation

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
hjc1
Newbie
Posts: 1
Joined: Sun Mar 06, 2011 3:23 am

Outlook Schedule Export Automation

Post by hjc1 » Sun Mar 06, 2011 3:37 am

I need to automate the outlook calendar export process. The steps were fairly straight forward until i reached a window that wants the start/stop dates. I have not been able to find a way to know which of the two spaces i am on in order to know what date to enclose. Please help :?

The outlook 2007 file export process:
open the calendar
select File
Select Import/Export
Select Export to a file>>Next
Select Comma Separated Values(Windows)>>Next
Select Calendar folder>>Next
Set output folder>>Next
MapCustom Fields>>Finish
This is where the problem is. The "Set Date Range" popup opens but i can not find a way to choose which field to load the start/finish dates into. I can NOTalways depend on the window opening in the same status.

Thanks for your help and sorry for the long distraction if the solution is right in front of my eyes and i missed it.

User avatar
Marcus Tettmar
Site Admin
Posts: 7378
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Post by Marcus Tettmar » Tue Mar 08, 2011 10:28 am

Looks like you can do this with VBScript transparently:

http://www.thescriptlibrary.com/Default ... to%20Excel
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts