how can I get a listing...

  • Thread starter Thread starter Phillips
  • Start date Start date
P

Phillips

I would like to get a list of the Calender Items that are past due, that
have not been dismissed.
Is there a way I can furthermore get ones that have been set to a certain
catigory?


I would like this in a VBA format so I can call it from excel. Maybe even a
way to fill this info into a worksheet.

Thanks
Phil
 
Take a look at the Restrict and Filter metode of Outlook. With these metodes
you should get the desired items.
To move these items into an Excel sheet, I think you would have to create a
reference to Excel and then use the metodes that Excel exposes. AFAIK you
must loop through the items and write each item into the sheet.
 
Back
Top