I want the Blocked Sender’s List in a format that will allow me to really edit the list of blocked addresses and domains. The “Remove” and “Remove All” functions aren’t cutting it. I also need to be able to copy the list so I can easily add it to our Symantec mail gateway’s custom black list. I’d be satisfied with the ability to copy and paste into notepad. I don’t need any fancy export formulas, etc.
I understand that the list resides in the “Calendar Profile”. I also understand that the calendar profile contains all of the calendar and mail settings. How do I open the calendar profile so that I can see the blocked senders list? Thanks.
In case anyone else is wondering how to do this, I finally figured out a crude way of getting the blocked sender’s list in a text file. I created an agent in the mail file I wanted to export and wrote this code to pull the blocked addresses out of the calendar profile:
Sub Initialize
Dim s As New notessession
Set db = s.CurrentDatabase
Set prefDoc = db.GetProfileDocument("CalendarProfile")
Set BlockList = prefdoc.GetFirstItem("$Filter_BlockAddressList")
Blocklistarray = blocklist.values
y = Ubound(BlockList.Values) + 1
Msgbox y
Open "c:\documents and settings\ecb\desktop\blocklist.txt" For Append As 1
x = 0
While x < y
Write #1, Blocklistarray(x)
x = x +1
Wend
End Sub
Here are a couple of things I wish I had known before I started figuring this out:
The calendar profile is special type of document that doesn’t show up in any views. do a search in Designer for “Profile Document” to get more details.
the actual field that contains the blocked addresses is “$Filter_BlockAddressList”. I had to pull the addresses out and put them into an array to write them to a text file.
I still haven’t figured out how to make this lotusscript “external” to a database. This would allow me to run it on any database I want without having to create an agent in each one. That would be helpful knowledge to have. I’m also trying to figure out how to “upload” a list of blocked addresses so that I can make changes to a blocked sender’s list in a more efficient manner. Hope this helps someone . . .
This worked perfectly. I Only wish as you do that there was a way to program a button with this code so I can access the information from the Admin client without adding an agent to the database.
The way that I’d make it ‘external’ is to create a new database. Put a form on it, where you can enter the server & database path. Then, you can have an action that pulls that info, goes out to the specified database, and grabs the list.
That’s how I grab profile docs. I’ve got a drop-down where I select a server. Then, a button to get a list of files/paths on that server. Then, select a path from a drop-down. Lastly, my action button goes out to the specified database, grabs all profile documents and their fields/values. It comes in handy every once in a while.