VBOffice
Home Products VBA Macros Tips & Tricks Contact Imprint Sprache wechseln Deutsch

Run-a-Script Rule

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

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

Content

SAM SAM
Determine the "identity" of your emails. Set with SAM the sender and the folder folder for sent items with the help of rules.

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
Category-Manager Category-Manager
With Category-Manager you can group your Outlook categories, share them with other users, filter a folder by category, automatically categorize new emails, and more. You can use the Addin even for IMAP.
email  Send a message
◀ Previous sample ▲ Top Next sample ▶

All names, products and pictures are under the copyright of the respective producers.

Microsoft and the Office logo are trademarks or registered trademarks

of Microsoft Corporation in the United States and/or other countries.