If you want something to share with co-workers, that should be an add-in. There is no supported method for distributing VBA code; see
http://www.outlookcode.com/article.aspx?id=28
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"Totem" wrote in message ...
I didn't have it under "ThisOutlookSession", so I've placed the code there
and it works now. Is this the only way? there's no way to have it in a
module so that I can easily share it with co-workers?
I'd like to know what's the easiest that I can share it with others and have
them update it as I provide them with a new version.
thanks
"Sue Mosher [MVP-Outlook]" wrote:
No, you don't have to write an add-in. Does other VBA code run? Have you checked the basics at http://outlookcode.com/article.aspx?id=49?
BTW, that's not a macro; it's an event handler.
"Totem" wrote in message ...
Hi,
I'm trying to capture the ItemSend event from a macro (not an add-in), but
for whatever reason it's not hitting it. Even after restarting Outlook
(2007), it does not kick in. Do I have to do something special?
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
MsgBox("hi")
End Sub
or do I have to write an add-in?