Re: search result
** If you record the macro with the user toolverify it creates the csv in the place that you want. Then have the Escalation execute a run process that calls runmacro.exe. Then a second action that performs a PERFORM-ACTION-ADD-ATTACHMENT [] to attach the file to a record...then you can use a standard notification to send the email L. J. HeadSoftware EngineerRemedy Approved Consultant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Addis SolomonSent: Friday, October 13, 2006 4:16 PMTo: arslist@ARSLIST.ORGSubject: Re: search result ** L.J, I am not familiar with the submitting a query email, but how can I get the esclation to generate the csv after I generate a report macro?"L. J. Head" <[EMAIL PROTECTED]> wrote: ** Have you tried submitting a query email?I've never used one...but the old email engine provided capability to email the remedy server with a query and it would return the results in the body of the emailor you could generate a report macro...and have the escalation generate that csv and then email the csv to them L. J. HeadSoftware EngineerRemedy Approved Consultant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Addis SolomonSent: Friday, October 13, 2006 3:15 PMTo: arslist@ARSLIST.ORGSubject: search result ** I want to include a search result from a form in a notification and email a user on a daily basis. The search result I am getting from a form is between 150 to 200 records. The data changes every day. What is the best way to include the search result in the escalation so the user can receive one single email everyday? I will appreciate your help. kind regards Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: search result
I want to include a search result from a form in a notification and email a user on a daily basis. This is something I have recently done. I started by using an external (Visual Basic) script, saving the results to a (.txt) file then sending the file in the E-mail. This required a separate script for each report and workflow external to ARS. Very labor intensive to revise reports when needed. I plan on retiring and becoming a ski bum in the next year. My future replacement wanted the process simplified a bit. Recently I revised the process. Started with creating a new Remedy Form. This form uses three fields: address, text message, and attachment. The form started out as a process to E-mail a Spreadsheet (Created with script) once a week. Remedy workflow is used to Add Attachment and send as an E-mail notification to the address. I revised the form to send a text message. I use a script to create a file (.csv) and import into the Remedy Form. The .csv file contains the address and text of the message. Merge workflow sends the message. Once the process was working, I revised the process to send the reports to a Remedy Group. This simplifies (no script revision) the changing who receives the messages. The process still depends on scripts to search Remedy and process the information into report files. I have reduced the number of scripts being used by making them as generic as possible. One script to create spreadsheets sent as attachments. One script used to create the text messages. George Treisbach Harrisburg, Pa. Copper Mtn, Co. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: search result
** L.J, I am not familiar with the submitting a query email, but how can I get the esclation to generate the csv after I generate a report macro?"L. J. Head" <[EMAIL PROTECTED]> wrote: ** Have you tried submitting a query email?I've never used one...but the old email engine provided capability to email the remedy server with a query and it would return the results in the body of the emailor you could generate a report macro...and have the escalation generate that csv and then email the csv to them L. J. HeadSoftware EngineerRemedy Approved Consultant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Addis SolomonSent: Friday, October 13, 2006 3:15 PMTo: arslist@ARSLIST.ORGSubject: search result ** I want to include a search result from a form in a notification and email a user on a daily basis. The search result I am getting from a form is between 150 to 200 records. The data changes every day. What is the best way to include the search result in the escalation so the user can receive one single email everyday? I will appreciate your help. kind regards Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates. __20060125___This posting was submitted with HTML in it___
Re: search result
** Have you tried submitting a query email?I've never used one...but the old email engine provided capability to email the remedy server with a query and it would return the results in the body of the emailor you could generate a report macro...and have the escalation generate that csv and then email the csv to them L. J. HeadSoftware EngineerRemedy Approved Consultant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Addis SolomonSent: Friday, October 13, 2006 3:15 PMTo: arslist@ARSLIST.ORGSubject: search result ** I want to include a search result from a form in a notification and email a user on a daily basis. The search result I am getting from a form is between 150 to 200 records. The data changes every day. What is the best way to include the search result in the escalation so the user can receive one single email everyday? I will appreciate your help. kind regards Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___