'Enable Macros' and Outlook Security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it dangerous to set Outlook security to 'Low'? I have VBA code that will run on all machines within my company. I don't want users to have to select 'Enable Macros' for every session if it can be avoided. Is this avoided by setting my VBA file as a trusted source? If so, how do I do that
Thanks.
 
I don't consider it dangerous, since Outlook VBA is not document-based as it is in Word or Excel. I find it more effective, though, to set it to Medium so that I know when VBA has actually loaded.

However, if you have code that you want to run on each machine, it shouldn't be in VBA. It should be in a COM addin.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
 
Yes, I agree, but I am having issues with my .NET Add In picking up the ItemSend event. It does not get called.
I want to take some action on the send of an item, but can't seem to get my .NET Add In to pick up the event. I can pick up the event in the VBA code, so I figured I was forced to handle it there. Is this the case?
If not, you don't happen to have a .NET code sample do you?

Thank you very much.

----- Sue Mosher [MVP] wrote: -----

I don't consider it dangerous, since Outlook VBA is not document-based as it is in Word or Excel. I find it more effective, though, to set it to Medium so that I know when VBA has actually loaded.

However, if you have code that you want to run on each machine, it shouldn't be in VBA. It should be in a COM addin.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
 
Actually, I have found some .NET code examples, but I can't get mine to work, which is why I was going to the VBA code. I get an error when I try to define my ItemSend function as follows

Dim WithEvents applicationObject As Outlook.Applicatio
....
....
Private Sub applicationObject_ItemSend(ByVal Item As Object, ByVal Cancel As Boolean) Handles applicationObject.ItemSen
MsgBox("item send"
End Su

The error I receive is a Method 'applicationObject_ItemSend' cannot handle Event 'ItemSend' because they do not have the same signature

If I remove the 'Handles...' clause, it will compile, but I never see the message box.

Any idea what I am doing wrong? It seems to me that I am doing this correctly..

Thanks
----- Geoff wrote: ----

Yes, I agree, but I am having issues with my .NET Add In picking up the ItemSend event. It does not get called.
I want to take some action on the send of an item, but can't seem to get my .NET Add In to pick up the event. I can pick up the event in the VBA code, so I figured I was forced to handle it there. Is this the case?
If not, you don't happen to have a .NET code sample do you

Thank you very much

----- Sue Mosher [MVP] wrote: ----

I don't consider it dangerous, since Outlook VBA is not document-based as it is in Word or Excel. I find it more effective, though, to set it to Medium so that I know when VBA has actually loaded.

However, if you have code that you want to run on each machine, it shouldn't be in VBA. It should be in a COM addin.
--
Sue Mosher, Outlook MV
Outlook and Exchange solutions at http://www.slipstick.co
Author o
Microsoft Outlook Programming: Jumpstar
for Administrators, Power Users, and Developer
 
Back
Top