Run a view from a green screen menu?
I am writing a view that will be run from a "green screen" menu option. This prompted view will create an .xls file which will then be emailed to the user to be used as a mail merge file in MS Word. Only two users will be choosing this option but I have not been able to devise a way to email it ONLY to the one taking the option. Any ideas?
Login to post new content in forum or to comment on an existing forum post.
Need Help?Talk to UsIn the U.S. and Canada, call 1-800-328-1000 and ask for Sales. Elsewhere in the world, contact your local international office. |
Run a view from a green screen menu?
Thanks, Dave!
With the help from Sequel Support, I wrote a CL program that retrieves the User Name from the job attributes and then assigns a variable (&USERID) equal to the email address of the user. I then email the file directly from the view with the parameter RECIPIENT(&USERID).
I used a CL rather than a script so I could compile the program with *OWNER so there would not be authority issues with the CLRPFM command.
Watson Clark
Run a view from a green screen menu?
Watson
Try runing the view via a script.
Within the script, execute the view with recipient set to &USERID.
On the script's variable tab, ensure that the definition of &USERID has a default value of *USER and a prompt text of *NOPROMPT.
Dave Cope