[Spambayes] Outlook Macro Security broke SpamBayes-- Bug but probably not in SpamBayes

[Herb Martin]

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