importing reminders from outlook into an excel calendar template

[Guest]

Excel and outlook 2003
Is there a way to import reminders set up in outlook into an excel template?
I found and downloaded a template from microsoft.com. The one I used was
this one:
http://office.microsoft.com/en-us/templates/TC011585891033.aspx?CategoryID=CT011371131033
I have been searching all morning for the answer.
thanks

 

[Ken Slovak]

Reminders aren't separate items, they are a property (ReminderSet) of items.
That property is available in the Outlook object model for mail, task and
appointment items. For contacts you'd have to use undocumented property tags
with CDO 1.21 or Extended MAPI or Redemption (www.dimastr.com) to read the
ReminderSet property. Additional properties are available for when the
reminder is due to fire.

You'd have to write code to iterate every folder's Items collection where
items with reminders might live and get the items with ReminderSet = True
and then export them into Excel.