Excel/Outlook integration

[chrischik]

This is a tricky one hopefully someone has a suggestion. We're trying to implement a better system of management for our library at work. I have two questions for this
1: I'd like Outlook to send a mail automatically after four weeks if the book/cd hasn't been returned. (I think this will require integration with Excel, but I'm not sure how to do this

2: If I receive no e-mail response to that mail within 3 days I would like Outlook to send another "reminder".

I'm sure this must be possible.
We have Office 2000/XP/2003 rofessional at our disposal (XP is more common in our company than 2003
and MS Exchang

I've also posted this in the Outlook group as I'm not really sure which program needs to do what first

Thanks in advance

Chri

 

[Dave Peterson]

If I were looking to do this, I'd visit these two sites and steal as many ideas
(and macros) as I could:

http://www.rondebruin.nl/sendmail.htm
http://www.dicks-clicks.com

The first is Ron de Bruin's; the second is Dick Kusleika's.