[Spambayes] Outlook Macro Security broke SpamBayes -- SOLUTION

Herb Martin HerbM at LearnQuick.Com
Mon Jun 6 02:45:38 CEST 2005


SpamBayes was not functioning, apparently disabled.

After sending the following request for help and 
temporarily letting the matter drop until someone
had an idea, I stumbled over the solution by 
accident...

Solution:
=========

Outlook 2003:  Menu HELP->About->Disabled Items(button)

	Re-enable SpamBays etc on the dialog

[Maybe everyone else already knows this but I have been
doing Windows, Office, AND Outlook about as long anyone
and it never occurred to me to enable software in the
"About" -- that should be strictly for version numbers
and other read-only items. ]

Original post follows...thanks.

Problem:  
========
After changing the Macro security SpamBayes no longer functions. 

  Precise symptoms, versions, steps to cause it
  and attempts to correct it are detailed below.

  I read the troubleshooting guide where it suggested:
  "If you also mention that you read this trouble-shooting
  guide...more likely to get answered!"

Versions:
=========

	Microsoft Windows [Version 5.2.3790]
	spambayes-1.1a1.exe
	Outlook 2003 (11.6359.6408) SP1

First confession:  I caused it.

Second: All finger pointing here is at Microsoft Outlook but I think
SpamBayes will get blamed and maybe abandoned by others who don't understand
the Microsoft code-signing rules. (Which is probably about everyone. <grin>)

Third: I LOVE SpamBayes (thanks folks!)

Symptoms:
=========
	1) SpamBayes. after working for years, is
	not classifying spam into Spam or Probable
	Spam folders

	2) Selecting message and pressing "Delete as Spam"
	does nothing except flash the button (no delay as
	if processing, message doesn't move.)

	3) SpamBayes configuration drop-down no longer
	drops down.
    
	4) After changing Macro security, I initially
	received some warning messages about the session
	containing macros -- exact message text is now
	unavailable, likely because I corrected the 
	macro part of the problem -- but there was no 
	specific mention of SpamBayes.


Steps that likely caused it, from the beginning:
=================================================

SpamBayes was working (for years).

Macro security was set to Medium with
"Trust All installed..." checked:

  Menu->Tools->Macro->Security->Security Level
    Tab>Trusted Publishers 
      CHECKED: 
	"Trust All installed add-ins and templates"
		
I set it to Low and cleared check box (temporarily) to get an unsigned macro
to run as a test.* SpamBayes was not working shortly afterwards and likely
quit working at this point -- SpamBayes has not worked since.  (No
classification/no button response)

*When making those changes I was attempting to follow the suggestions in the
Outlook VBA editor Help entitled:
 
"Security Notes for Microsoft Office Solution Developers"

Steps to correct (unsuccessful):
================================
  Restored original settings
  Restarted Outlook multiple times
  Used the Self Signing tool to create a VBA
    local certificate, and signed my VBA code.
	This stopped the macro warning/error each
	time I reloaded Outlook. 
	(This fixed macros issue too.)
  Re-checked all settings to make sure I was
	again at "Medium" and "Trust all installed"
  Re-installed SpamBayes
  Restarted Outlook multiple times

Checked Add-in Manager...
  Menu->Tools->Options->tab Other->Advanced Options:
    Add-in Manager:  SpamBayes does not appear
			(three other add-ins do)
    COM Add-ins: SpamBayes does not appear
      chose ADD & navigated to SpamBayes bin
	  directory and attempted to add: outlook_addin.dll
	  Outlook gives no error but returns to
	  Add-ins available, without displaying SpamBayes.
    **See Below

SpamBayes still appears in Tools->Customize
	-> Tools bars (of course)	 

Reduced Security to Low (with Trust all... CHECKED):
  Restarted Outlook
  **SpamBayes appeared (unchecked) in Add-in Manager:
  Checked and exited Add-In Manager (Ok, Ok,...):
	SpamBayes doesn't' work, back to Add-In Manager:
		SpamBayes is UNCHECKED (again)
		Checked SpamBayes again
  Exited Outlook
	SpamBayes doesn't work -- still unchecked
  
Caveat: When I say "Exited" or "Restarted" Outlook, I not only exit/restart
but also checked with:

 tasklist /Fi "Imagename eq outlook.exe"

 AND/OR

 TaskKill /IM outlook.exe

Again, thanks to anyone who tries to help or even reads this whole message
-- I love SpamBayes and recommend it frequently.

Herb Martin, MCT, MCSD, MCSE, MVP
HerbM at LearnQuick.Com http://LearnQuick.Com
512 388 7339   -or-   1 800 MCSE PRO
Accelerated MCSE in a Week Seminars

_______________________________________________
Spambayes at python.org
http://mail.python.org/mailman/listinfo/spambayes
Check the FAQ before asking: http://spambayes.sf.net/faq.html



More information about the Spambayes mailing list