outlook automatic email reminder

i need to solve this situation. i have outlook 2003 and i need to have automatic emails sent out for my appointments according to reminder time set. for example i create New appoinment in my calender and add invitees. automatically there is an email sent out right away. But then i set a reminder lets say 1 day. so when that reminder activates i need not only a popup reminder for me but also an automatic email sent out the invitees.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David LeeCommented:
Hi rejus,

This is possible in several different ways.  First, a third-party add-in or utility.  Here's a link to a page listing a variety of Outlook add-ins: http://www.slipstick.com/addins/notify.htm  Second, an Outlook macro.  It wouldn't be very tough to do this.  The downside is that macros only run while Outlook is open and running.  It would not be able to send a reminder while you were off-line.  Third, an Exchange event sink.  Event sinks are rules that run at the Exchange server.  They are more difficult to write than an Outlook macro and since they run at the server any error or bug will affect the entire server not just one user.  Of course if you aren't using Exchange, then this isn't an option.

rejusAuthor Commented:
exchange server is def not an option
so it leaves me with
1. macro
2 slipstick page addons

can you help me with macro first.
have you have experience or recommend any of the third party addins?
David LeeCommented:
I don't have any experience with add-ins and can't make a recommendation.  Yes, I can help with the macro.  I'll post the code for that within the next 24 hours or so.
David LeeCommented:
The code for doing this appears below.  Follow these instructions to use it.
1.  Start Outlook
2.  Click Tools->Macro->Visual Basic Editor
3.  If not already expanded, expand Microsoft Office Outlook Objects and click on ThisOutlookSession
4.  Copy the code below and paste it into the right-hand pane of the VB Editor window
5.  Edit the code making the changes per the comments I embeded in the code
6.  Click the diskette icon on the toolbar to save the changes
7.  Close the VB Editor
8.  Click Tools->Macro->Security
9.  Set the Security Level to Medium.  
10.  Close Outlook
11.  Start Outlook
12.  Outlook will display a dialog-box warning that ThisOutlookSession contains macros and asking if you want to allow them to run.  Say yes.

Here's how the code works.  It watches for reminders firing and checks to see if a fired reminder is for an appointment.  If it is, then it creates a new message, addresses it to everyone the appointment includes, and sends it off.  The act of sending a message from code is going to trigger Outlook's built-in security.  This will cause a dialog-box to pop up warning that an application is trying to send mail and asking for your permission to allow it to continue.  There are three ways around this.  One, re-write the code as an Outlook add-in.  Add-ins have different security constraints.  Two, use ClickYes (http://www.contextmagic.com/express-clickyes/) a free third-party tool that will click the Yes button for you when the security dialog appears.  Three, use Outlook Redemption (http://www.dimastr.com/redemption) a third-party library that circumvents Outlook security.

'Code Begins Here
Dim WithEvents olkReminders As Outlook.Reminders

Private Sub Application_Quit()
    Set olkReminders = Nothing
End Sub

Private Sub Application_Startup()
    Set olkReminders = Application.Reminders
End Sub

Private Sub olkReminders_ReminderFire(ByVal ReminderObject As Reminder)
    Dim olkReminderMessage As Outlook.MailItem, _
        olkRecipient As Outlook.Recipient
    If ReminderObject.Item.Class = olAppointment Then
        Set olkReminderMessage = Application.CreateItem(olMailItem)
        With olkReminderMessage
            'Change the subject ext on the following line as desired
            .Subject = "Appointment Reminder: " & ReminderObject.Item.Subject
            For Each olkRecipient In ReminderObject.Item.Recipients
                If olkRecipient.Name <> Session.CurrentUser Then
                    .Recipients.Add olkRecipient.Name
                End If
            'Change the message body text on the following line as desired
            .Body = "Please don't forget about this appointment."
        End With
    End If
    Set olkReminderMessage = Nothing
End Sub
'Code Ends Here

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David LeeCommented:
Any update, rejus?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.