Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 07-24-2015, 02:31 AM
gmayor's Avatar
gmayor gmayor is offline Can I make emails with reminders show up on the Calendar? Windows 7 64bit Can I make emails with reminders show up on the Calendar? Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,142
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The following macros will add a reminder and an appointment at the same time. You can choose how many days to add (to today) to place the appointment and reminder. Put the macros in the same (new) module, select a message and run the macro 'RemindMsg'. You can add this macro to the ribbon for ease of access.

You may need to use SelfCert.exe to sign the macro.

Code:
Option Explicit

Sub RemindMsg()
Dim olMsg As MailItem
    On Error GoTo err_handler
    Set olMsg = ActiveExplorer.Selection.Item(1)
    FlagMessage olMsg
lbl_Exit:
    Exit Sub
err_handler:
    MsgBox Err.Number & vbCr & Err.Description & vbCr & vbCr & _
           "Ensure you have a message selected before running the test macro!"
    GoTo lbl_Exit
End Sub

Public Sub FlagMessage(olItem As Outlook.MailItem)
Dim strTime As String
Dim strDays As String
    strDays = InputBox("Remind in how many days?")
    If strDays = "" Then strDays = 1
    strTime = Now + Val(strDays)
    With olItem
        AddAppt .Subject & " - " & .SenderEmailAddress, strTime
        .MarkAsTask olMarkThisWeek
        .ReminderSet = True
        .ReminderTime = strTime
        .Save
    End With
lbl_Exit:
    Exit Sub
End Sub

Public Sub AddAppt(strSubject As String, strTime As String)
Dim objApt As AppointmentItem
    Set objApt = Application.CreateItem(olAppointmentItem)
    With objApt
        .ReminderSet = False
        .Subject = strSubject
        .Start = strTime
        .AllDayEvent = True
        .Save
    End With
lbl_Exit:
    Exit Sub
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
The entries on my Outlook Calendar are not showing up in my email as reminders Sue K. Outlook 0 10-29-2014 07:01 AM
Outlook 2013 calendar reminders disabled on my calendar but show on boss's when i send invites WUPJ Outlook 0 08-06-2014 05:29 AM
Calendar Reminders to Invitees jdc15371 Outlook 0 06-26-2014 08:13 AM
Outlook 2010 - Imported Calendar and Reminders nickolasj80 Outlook 2 10-26-2011 01:34 PM
Calendar Reminders Inoperative ljleovic Outlook 0 08-10-2011 10:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft