Interfacing OL2002 Cal and Excel Userforms

[Bruccce]

I need to schedule 5 min appointments (and make sure that the time is avail,
if not, what is the next free time after that) for a call back to a contact,
and then have excel remind me about this appoint with a msgbox (if excel is
running! and the given worksheet is open) and if I press OK (or "CallNext")
on the msgbox, to have that cust scheduled as the next contact.
I am using userforms most of the time, if that makes any difference.



Thanks
Bruce

 

[Dick Kusleika]

Bruce

Here's a place to start

http://www.dicks-clicks.com/excel/olCalendar.htm

Since Outlook has such a nice reminder feature, I don't know why you would
want a reminder in Excel.

We'll need more details on where your contacts are stored, what kind of code
you have behind your userform, and stuff like that for more detailed
answers.