I am using the following code to update a sent item (because of problems we are having with the InetSendTo field):
ViewName:=@ViewTitle ;
ViewNameT:=@Text(ViewName);
@If(ViewName!=“($Sent)”;
@Do(
@Prompt([Ok];“Sorry”;“You can only use this button from the Sent Items View. You are in the " + ViewNameT + " View. You will now be navigated to Sent Items, where you need to navigate to the email you wish to import.”);
@Command( [OpenView] ; “($Sent)” );
@Return(“”));
“”);
@If(INetSendTo!=“.”;“”;
@Do(
@SetField(“INetSendTo”; SendTo)));
@If(INetCopyTo!=“.”;“”;
@Do(
@SetField(“INetCopyTo”; CopyTo)));
FIELD SendTo:=SendTo;
n := 1;
@While(n <= @Elements(SendTo);
database := @Subset(@DbName; -1);
server := @Name([CN]; @Subset(@DbName; 1));
noteslookup:=@If(server=“”;
@DbLookup(“Notes”:“”; “”:NAMES.nsf;“People”;@Name([CN];SendTo[n]);“InternetAddress”);
@DbLookup(“Notes”:“”;“85255F7E:11122222”;“($NamesFieldViewName)”; @Name([CN];SendTo[n]);“InternetAddress”));
GetFirstName:=@Left(SendTo[n];4);
FirstLetter:=@LowerCase(@Text(@Right(GetFirstName;1 )));
Surname:=@LowerCase(@RightBack(@Name([CN];SendTo[n]);" "));
@If(@Contains(SendTo[n];“>”);
@Set(“Trimmed”;@MiddleBack(SendTo[n]; “>” ; “<” ));
“”);
Addr821:=@If(@Contains(SendTo[n];“CN=”);
@If(!@IsError(noteslookup);
noteslookup;
@Prompt([OkCancelEdit]; “Sorry! We could not find the relevant email address,”; “Please enter the correct address in the box below. We have made a suggestion for you, which needs to be changed to the correct address”; “” + FirstLetter +Surname+ “@companyname.com”));
@Name([Address821];SendTo[n]));
ABSendTo:=@If(@Contains(Addr821;"@companyname.com");Addr821;INetSendTo[n]);
@If(@Contains(Addr821;"@companyname.com");
@Set(“tempvar”;tempvar + “;” + ABSendTo);
“”);
n := n + 1);
@If(@Contains(Addr821;"@companyname.com");
@SetField(“INetSendTo”;@Explode(tempvar));
“”);
@If(Trimmed!=“”;
@SetField(“INetSendTo”;@Explode(Trimmed));“”);
@Prompt([Ok];“Thank You " + @Text(@Left(@Name([CN];@UserName);” ")) + “.”; “Your email is now ready to be imported into Siebel.”)
It occoured to me today because of a support issue, I have not included the @Command([FileSave])…
Should it still set the field, at the moment the result is inconsistent, sometimes it sets the field (especially if I am in control of the users PC!!!), but sometimes it doesn’t?
Should I have to FileSave it…