Hi,I need to perform the following actions, from an email button, preferably using @Commands, or Formula, as I have had many many problems with my LS for this, and have given up with it…
Basically, we want to:
-
Send the users an email with a button in it;
-
On pressing the button, a file which is also on the email is downloaded to C:\Program Files\Lotus\Notes\Data
-
Then, we need to open this database
-
Here comes the tricky part. I’d ideally then like to automatically press the ‘Test Setup’ button that appears. This test setup button contains very good, working code, that is able to do many things, including set environment variables exactly how we require. It was written by someone with a much better understanding of script than I.
-
Then, just want to close the database following the user pressing OK to the prompt that appears…
I’d like to avoid further modification to the database ideally (I don’t really want to create an agent for example), just need to somehow automatically press the button for the user!
I also can’t move the code into the email button (for various reasons, partly as I think the problems I am having with the LS button are based on the fact we are trying to run it in the users mailfile and I beleive there may be ECL/Access issues of some kind, preventing the code from running, wheras I know it works in the database…
So far the code in the button is quite basic:
@Command( [EditDetach];“Siebel7Email.nsf”;“C:/Program Files/Lotus/Notes/data/Siebel7Email.nsf”);
@Command([FileOpenDatabase]; “”:“Siebel7Email.NSF”; “”; “”; “”; “1” )
(then it needs to @Command([PressButton];“TestSetup”);
@Command([FileCloseWindow])