Export Calendar for selected week

[Richard John]

I want to automate the export of a week's calendar entries from Outlook to a
CSV file. I've done it using the OL interface. However, I need to automate
these steps:

a./ derive a unique filename

b./ Select the date range

c./ export to CSV file as unique filename

d./ Add the file as an email attachment

e./ Send the email

The ultimate idea is to read the dumped data into Access to produce reports
(can handle this part ok). However, I'm having difficulty finding anything
on th M$ site that can help me with OL VBA (No macro recording available
with OL). Can anyone point me to a suitable resource please...?



TIA



Richard John

Melbourne, Australia

 

[Sue Mosher [MVP-Outlook]]

You might want to start with these pages:

http://www.outlookcode.com/d/customimport.htm
http://www.outlookcode.com/d/finddate.htm

ANd if you're new to Outlook VBA macros, these web pages should help you get started:

http://www.winnetmag.com/Articles/Index.cfm?ArticleID=21522&pg=1
http://www.outlookcode.com/d/vb.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers