Export each calendar entry to a text file between two dates

A

Arry Potter

Hi,
I am new to outlook vba and need a code which can export each of my
calendar entry between two dates to a text file. All I want it to do is to
extract each calendar entry (fields : from,subject,location,body) and dump
this to a text file with the appointment name as the text file name.This
should be done for all entries between two dates. SO if I have 10 calendar
appointments it must create 10 files with the appointmnent name as the file
name.

Please help me as this is an urgent requirement
 
M

Michael Bauer [MVP - Outlook]

For gettign the appointments, you may adapt this sample:
http://www.vboffice.net/sample.html?mnu=2&pub=6&lang=en&smp=13&cmd=showitem

If you can live with how Outlook saves the file, simply call each item's
SaveAs method:

Item.SaveAs "c:\" & Item.Subject & ".txt", olTXT

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool
: <http://www.vboffice.net/product.html?pub=6&lang=en>



Am Mon, 8 Sep 2008 17:24:01 -0700 schrieb Arry Potter:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting calendar to file - completely ridiculous! 4
Create appointment to custom (shared) outlook calendar 3
Outlook calendar/add new entry with Exchange & IMAP 2
add an appointment for a custom calendar, vba excel 2
Outlook Calendar 1
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Outlook 2003 Calendar entry issues 2
Total appointments per agent 2

Top