View icon help

Hi, probably a very easy thing to but I want a icon to show in the inbox view when the $dnsblsite contains an entry so I know its spam.

I think I know the formula but not sure how to add it into the current formula which is

REM {This icon formula is used in ($Inbox) folder, (MailThreads) view, and ($All) view};

CSisPrivate := @If(@IsUnavailable($PublicAccess) & @IsAvailable($CSVersion);“1”;“0”);

isImportant := @If(Importance=“1”;“1”;“0”);

ViewIcon2 := @If(_ViewIcon = 158 & AppointmentType != “1” & BookFreeTime = “1”; 12; _ViewIcon);

tmpIcon := @If(ExpireDate !=“” ;64;displaycopyto_icon = “1”;“sentto.gif”;

@If(DeliveredDate = “”;

@If(PostedDate="" | @IsUnavailable(PostedDate);

    @If(@IsAvailable(IsMailStationery);

        21;

@If($dnsblsite=“bl.spamcop.net”);

    115;

    @IsAvailable(_ViewIcon);

        ViewIcon2;

     58);

@If(IsImportant="1";

    124;

122));

@IsAvailable(_ViewIcon);

ViewIcon2;

$TypeIcon));

REM; “If the Task has no icon, display the invitation icon - backward compatibility”;

varTaskIcon := @If(Form = “Task” & (!@IsAvailable(_ViewIcon) | ViewIcon2 = “”) & (!@IsAvailable(_ViewIcon2) | ViewIcon2 = “”); @False; @True);

iconOne := @If(!varTaskIcon; 133; @If(tmpIcon = “”; 0; tmpIcon));

iconTwo := @If(iconOne=124;0;CSisPrivate=“1”; 164; isImportant=“1”; 150; 0);

iconOne:iconTwo;

If anybody can help that would be great

thanks

Scott

Subject: View icon help

If you add @IsAvailable($DNSBLSite);87; to the end of the tmpIcon := line, you’ll get a little frowny face next to anything flagged with a $DNSBLSite item, regardless of the blacklist used. The full column formula I tested in the R6 mail template is below.

REM {This icon formula is used in ($Inbox) folder, (MailThreads) view, and ($All) view};

CSisPrivate := @If(@IsUnavailable($PublicAccess) & @IsAvailable($CSVersion);“1”;“0”);

isImportant := @If(Importance=“1”;“1”;“0”);

ViewIcon2 := @If(_ViewIcon = 158 & AppointmentType != “1” & BookFreeTime = “1”; 12; _ViewIcon);

tmpIcon := @If(ExpireDate !=“” ;64;displaycopyto_icon = “1”;“sentto.gif”;@IsAvailable($DNSBLSite);87;

@If(DeliveredDate = “”;

@If(PostedDate="" | @IsUnavailable(PostedDate);

    @If(@IsAvailable(IsMailStationery);

        21;

    @IsAvailable(_ViewIcon);

        ViewIcon2;

     58);

@If(IsImportant="1";

    124;

122));

@IsAvailable(_ViewIcon);

ViewIcon2;

$TypeIcon));

REM; “If the Task has no icon, display the invitation icon - backward compatibility”;

varTaskIcon := @If(Form = “Task” & (!@IsAvailable(_ViewIcon) | ViewIcon2 = “”) & (!@IsAvailable(_ViewIcon2) | ViewIcon2 = “”); @False; @True);

iconOne := @If(!varTaskIcon; 133; @If(tmpIcon = “”; 0; tmpIcon));

iconTwo := @If(iconOne=124;0;CSisPrivate=“1”; 164; isImportant=“1”; 150; 0);

iconOne:iconTwo