VBOffice

Run-a-Script Rule

This explains the basics for writing macros that can be run by a rule.

Last modified: 2006/12/11 | Accessed: 28.768  | #39
◀ Previous sample Next sample ▶

Content

Category-Manager Category-Manager
Access the master category list in the blink of an eye, share your color categories in a network, get a reminder service, and more.

Rule for Emails

Since Outlook XP you can create rules to call a VBA macro for incoming emails. The requirements are that the macro is declared as public, located in the module ThisOutlookSession or in a standard module (no class module), and that there's a variable for the MailItem to be passed.


tip  How to add macros to Outlook
Public Sub Sample(Item As Outlook.MailItem)
  'do anythign here with the email
End Sub

Rule for Meeting Requests

If the macro is for meeting request items, you just need to change the data type in the declaration:

Public Sub Sample(Item As Outlook.MeetingItem)
  '...
End Sub
Reporter Reporter
VBOffice Reporter is an easy to use tool for data analysis and reporting in Outlook. A single click, for instance, allows you to see the number of hours planned for meetings the next month.
email  Send a message