Hi John, That sounds like pretty good solution. I have done something similar to automate emailing some basic reports (csv files) natively with only Remedy and OS commands. One note on your clean up, running an PERFORM-ACTION-DELETE-ATTACHMENT will not delete an attachment on the harddrive, only out of a Remedy attachment field. You can either do a run process that like "RUN PROCESS del <path>\<file.txt>" or create a small batch file that you can call from a filter and pass the file name to it.
Another option would be to use Crystal Reports if you have them. Crystal Server can send various format attachments (pdf, doc, xls) on a schedule or on an event (but it takes a kind of hokey work around to make events work). If you have Crystal Reports but not Crystal Server you can use CRexporter ( http://www.rainforestnet.com/crexport-download.htm). It is a free tool that can run a Crystal reports, export it in various formats. You can easly call it from a filter to run the report and email it. HTH, Jason On Tue, Jul 15, 2008 at 1:50 PM, Reiser, John J <[EMAIL PROTECTED]> wrote: > Hello Listers, > > ARS 6.3 Patch 21 > MS SQL Server 2000 > MS Windows 2000 > > Am I missing something basic? I have been asked to forward the Call Log > (Diary Field) along with a notification email as an attachment. > The only way I can think of doing this is to > 1. Use a RUN PROCESS runmacro.exe which runs a report to save the diary > field to a text file. > 2. Use a RUN PROCESS PERFORM-ACTION-ADD-ATTACHMENT <attachment fieldID> > <Path>\<File.txt> > 3. Use the Attachment field in the filter action that loads and sends a > message from the AR System Email Messages form. > > It doesn't need to be in one filter. It just has to be transparent to > the user and clean up after itself. RUN PROCESS > PERFORM-ACTION-DELETE-ATTACHMENT and delete the <path>\<file.txt> > > Am I on the right path or do it follow the twisty path into the gnarled > woods. go west > > > Thanks, > > John J. Reiser > Software Development Analyst > Remedy Administrator/Developer > Lockheed Martin - MS2 > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - paraphrased > by me > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
