Trigger macro to run when selected email is opened

Status
Not open for further replies.

djGrizzly

Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Hello, I am having trouble with my events in outlook, not sure if I am missing something or not.

I am trying to trigger a macro when the selected mail item in outlook is opened.

Using the code below, I can successfully trap the event and display the msgbox when double clicking the first item in my inbox.

Code:
Public WithEvents myItem As Outlook.MailItem 
 
Private Sub Application_ItemLoad(ByVal Item As Object)
     Set myItem = Application.Session.GetDefaultFolder(olFolderInbox).Items(1) 
 
End Sub 
 
Private Sub myItem_Open(Cancel As Boolean)
     Cancel = True
     MsgBox "opened an item" 
 
End Sub

However I am wanting to be able to display the msgbox for any email that is double clicked.

I am trying to use the code below, but it doesnt seem to work. Every time i double click on the email it is opening the email as normal and not triggering the msgbox.

Any ideas what I need to do different?

Code:
Public WithEvents myItem As Outlook.MailItem 
 
Private Sub Application_ItemLoad(ByVal Item As Object)
     Set myItem =Application.ActiveExplorer.Selection.Item(1) 
 
End Sub 
 
Private Sub myItem_Open(Cancel As Boolean)
     Cancel = True
     MsgBox "opened an item" 
 
End Sub

Thank you for your help.
 
When I use the first code so that it only works for the first item in my inbox, It is working consistently every time that i double click on the first email.

Also, I am assuming that you mean to write it such as this....

Code:
Option Explicit 
 
Public WithEvents myItem As Outlook.MailItem 
 
Sub Initialize_Handler()
     Set myItem = Application.ActiveExplorer.Selection.Item(1) 
 
End Sub 
 
Private Sub myItem_Open(Cancel As Boolean)
     Cancel = True
     MsgBox "Opening a MailItem" 
 
End Sub

This however does not seem to do anything when I am opening emails.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
Z Trigger macro to run after a new mail is received in Outlook? Using Outlook 3
R Trigger Application_ItemSend event when sending using Access macro Outlook VBA and Custom Forms 2
G Trigger script without restaring outlook Outlook VBA and Custom Forms 7
C must select message to trigger safe list Using Outlook 3
M Subject Line Automation - Trigger Script Delayed Outlook VBA and Custom Forms 2
T Sending One Email to Trigger Another Being Sent Using an Email within the 1st? Using Outlook 0
J dragging an calendar item to deleted folder does not trigger ItemRemove event Outlook VBA and Custom Forms 1
X Custom icon (not from Office 365) for a macro in Outlook Outlook VBA and Custom Forms 1
X Run macro automatically when a mail appears in the sent folder Using Outlook 5
mrrobski68 Issue with Find messages in a conversation macro Outlook VBA and Custom Forms 1
G Creating Macro to scrape emails from calendar invite body Outlook VBA and Custom Forms 6
M Use Macro to change account settings Outlook VBA and Custom Forms 0
J Macro to Reply to Emails w/ Template Outlook VBA and Custom Forms 3
C Outlook - Macro to block senders domain - Macro Fix Outlook VBA and Custom Forms 1
Witzker Outlook 2019 Macro to seach in all contact Folders for marked Email Adress Outlook VBA and Custom Forms 1
S macro error 4605 Outlook VBA and Custom Forms 0
A Macro Mail Alert Using Outlook 4
J Outlook 365 Outlook Macro to Sort emails by column "Received" to view the latest email received Outlook VBA and Custom Forms 0
J Macro to send email as alias Outlook VBA and Custom Forms 0
M Outlook Macro to save as Email with a file name format : Date_Timestamp_Sender initial_Email subject Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Macro GoTo user defined search folder Outlook VBA and Custom Forms 6
D Outlook 2016 Creating an outlook Macro to select and approve Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Macro to send an Email Template from User Defined Contact Form Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Macro to check Cursor & Focus position Outlook VBA and Custom Forms 8
V Macro to mark email with a Category Outlook VBA and Custom Forms 4
M Outlook 2019 Macro not working Outlook VBA and Custom Forms 0
S Outlook 365 Help me create a Macro to make some received emails into tasks? Outlook VBA and Custom Forms 1
Geldner Send / Receive a particular group via macro or single keypress Using Outlook 1
D Auto Remove [EXTERNAL] from subject - Issue with Macro Using Outlook 21
V Macro to count flagged messages? Using Outlook 2
sophievldn Looking for a macro that moves completed items from subfolders to other subfolder Outlook VBA and Custom Forms 7
S Outlook Macro for [Date][Subject] Using Outlook 1
E Outlook - Macro - send list of Tasks which are not finished Outlook VBA and Custom Forms 3
E Macro to block senders domain Outlook VBA and Custom Forms 1
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
N VBA Macro To Save Emails Outlook VBA and Custom Forms 1
N Line to move origEmail to subfolder within a reply macro Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Macro to answer a mail with attachments Outlook VBA and Custom Forms 2
A Outlook 2016 Macro to Reply, ReplyAll, or Forward(but with composing new email) Outlook VBA and Custom Forms 0
J Macro to Insert a Calendar Outlook VBA and Custom Forms 8
W Macro to Filter Based on Latest Email Outlook VBA and Custom Forms 6
T Macro to move reply and original message to folder Outlook VBA and Custom Forms 6
D Autosort macro for items in a view Outlook VBA and Custom Forms 2
S HTML to Plain Text Macro - Help Outlook VBA and Custom Forms 1
A Macro to file emails into subfolder based on subject line Outlook VBA and Custom Forms 1
N Help creating a VBA macro with conditional formatting to change the font color of all external emails to red Outlook VBA and Custom Forms 5
S Visual indicator of a certain property or to show a macro toggle Outlook VBA and Custom Forms 2
L Modifying VBA script to delay running macro Outlook VBA and Custom Forms 3
S Macro to extract and modify links from emails Outlook VBA and Custom Forms 3
M Replyall macro with template and auto insert receptens Outlook VBA and Custom Forms 1

Similar threads

Back
Top