Re: default url to go into mail

Since we use a load balancer we have a custom Login method that redirects 
the user to the correct Virtual Server. 
It looks up the users mail file and then creates the URL for them to the 
correct Virtual server.

Ex.

User  John Doe has a mail file on server   mail1/Acme

User signs into home page of the Intranet/Extranet and then the clicks the 
link for email which launches the  mailjump database. 

The mail jump database launches a  simple form with some computed fields 
that references the users name against the
 NAB and then looks up the associated Virtual server, then redirects to 
their mail file on the Virtual server. 

Here is an example of the computed field to look-up their mail server and 
send them to the proper load Balanced Virtual Server. 

oldserverID:=@Trim(@LowerCase(@DbLookup("":""; 
namesDB;"($Users)";username;"MailServer")));

a:=@Name([CN];@DbLookup("":"";"":"names.nsf";"($Users)";userID;6));
b:=@If(@IsError(a);"";@LowerCase(a));
@If(b="";"";
                @If(@Contains(b;"mail1");"GAmail.company.com";
                @If(@Contains(b;"mail2");"FLmail.company,com";
                @If(@Contains(b;"mail3");"MEmail.company.com"; 
                @If(@Contains(b;"mail4");"TXmail.company.com";
                @If(@Contains(b;"mail5");"CAmail.company.com"; 
                @If(@Contains(b;"mail6");"NYmail.company.com"; 
                @If(@Contains(b;".");b;b+MailFileDomain))))))))


Here is an example of the mail URL computed field. 

httpserver :=@If(serverID="";"";"http://"+@Name([CN];serverID)+ 
MailFileDomain );
mailfile                := @DbLookup("":""; namesDB;"($Users)"; userID; 
"MailFile");
temp            := "/mail/"+@Right(mailfile; "\\");

httpserver+ temp + @LowerCase(@If(@Contains(temp;".nsf");"";".nsf"))

Regards, 

Sean