Hi Friends,
I have questions on Client table. I have created a client table based on a sequel view. But I need to email the client table through Script using ESEND.
1) I need to schedule this script to email the receipients automatically. I know how to email a SEQUEL VIEW as follows:
RUNCMD CMD('EXECUTE VIEW(LIBRARY/VIEWNAME) PCFMT(*XLS) RECIPIENT(''xxx@abc.com;yyy@abc.com'') EMLMSG('***** EMAIL MESSAGE *****') TEXT('SUBJECT')
BUT I NEED TO KNOW HOW TO EMAIL A CLIENT TABLE TO PARTICULAR RECIPIENTS? WE HAVE ESEND AVAILABLE.
2) Even how to display a client table through a script?
SEQUEL VIEW - DISPLAY VIEW(*LIBL/VIEWNAME)
SEQUEL REPORT - REPORT REPORT(*LIBL/REPORTNAME)
SEQUEL CLIENT TABLE - ??? PLEASE HELP. I have tried many ways but not working. As of now I am displaying it through VPSHELLCMD.
I really appreciate if anyone can help me. I need the answer urgently.
Thank you,
Vijay