Export Calendar for selected week

  • Thread starter Thread starter Richard John
  • Start date Start date
R

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
 
Back
Top