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.
 

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

How I can access and change global address list option of schedule management? 0
Counting multiple memberships 1
I can't believe it's been 5 years... hello! (again) 9
VBA: How can I use a string variable as autofilter criteria? 4
reminder question 12
Can I retrieve a dismissed Reminder? 2
Copying List box values/selection to a database of sorts 2
Can't get appointments from other organizers 1

Back
Top