Outlook 2003 Subject Line
Posted on 2010-08-18
I want to make it so every user that sends an email must type something in the subject line. I have a VBS script that works.
"Private Sub Application_ItemSend _
(ByVal Item As Object, Cancel As Boolean)
If Item.Subject = "" Then
Cancel = True
MsgBox "Please fill in the subject before sending.", _
vbExclamation, "Missing Subject"
I wrote a batch file and added it to a gpo that runs it at login.
xcopy "\\server\Outlook Gpo\VbaProject.OTM" "\\%computername%\C$\Documents and Settings\%username%\Application Data\Microsoft\Outlook"
Within the same GPO I told it to set the macro security level to "Low" and to "Trust all installed add-ins and templates". I have added the Outlook 2003 gpo addon.
I have tested it on several different users, it only works once I go into outlook and tools, macro, security, and goto Trusted Publishers and check the "Trust all installed add-ins and templates". Then my VBS file starts working.
I am confused as of why the GPO isn't doing this for me. I have the VBS file signed by a certificate, and the certificate is also sent to all computers through a GPO (trusted root).
Any ideal why I have to go in and Trust all addins/templates each users profile (Why the GPO isn’t doing that for me)? If there is a registry key that changes then that would be a simple fix, any advise is greatly appreciated!
Side notes (I run gpupdate /force, when I change the gpo, and I have waited a day to be sure the “Trust all installed add-ins and templates” has had enough time to propagate.