PDA

View Full Version : Beginner needs advice on Outlook and VBA - exporting calendars



sharke
05-18-2010, 09:58 AM
What I need is to automate the process of exporting my Outlook calendars. I have around 12 calendars that I use to schedule appointments for my employees and I wrote a program in C which takes exported calendars and generates a summary of them which I use to invoice clients. Currently the most tedious part of the task is manually exporting all of the calendars (which involves many steps including physically typing in a range of dates for each calendar) and I would love to automate the process.

Is this an easy thing to do with VBA? Ideally I'd like to be able to run a script which allows me to select the date range on a calendar widget, then automatically export all calendars to text files for that range. I have absolutely no idea of VBA or what it can do, although I'm presuming that with my C and Java background I could pick it up relatively easily.