Logicity Forum  


Email report using adresses in report - 2008/04/17 16:10 Is it possible to email the report that is compiling to recipients within the refreshed report? Meaning if John doe's name populates in the report can the software then send the email to his address that is in the report? Brad Lansinger
  The administrator has disabled public write access.
Re:Email report using adresses in report - 2008/04/17 16:27 Brad,

We've typically done what you are talking about as a custom app bolted on top of Logicity, but with a litte creativity you can do it with Logicity by itself. What you'd want to do is develop an application or a report that exports out a valid Logicity RRD file and then run the resulting file through Logicity. For example, if I have a customer table that I want to burst out one personalized e-mail per customer, you'd want to output something like this:

Code:

  ;WORKSPACE_MODE=FALSE EmailReport[Bursted E-mail]=C:\Users\aellis\Desktop\Logicity Weekly Webinar\Report Files\01 Direct With No Password Needed.rpt?recip=customer1@domain.com&subj=Attn Bill Smith&msg=&export=Adobe Acrobat (PDF)&smtpserver=mail.server.com&smtpport=25&smtpauthentication=True&smtpuser=user&smtppassword=password&fromaddress=sales@server.com& EmailReport[Bursted E-mail]=C:\Users\aellis\Desktop\Logicity Weekly Webinar\Report Files\01 Direct With No Password Needed.rpt?recip=customer2@domain.com&subj=Attn Jan Miller&msg=&export=Adobe Acrobat (PDF)&smtpserver=mail.server.com&smtpport=25&smtpauthentication=True&smtpuser=user&smtppassword=password&fromaddress=sales@server.com&



...where each of the detail records of your application or report is writing a new EmailReport line. Make sense?

Adam
  The administrator has disabled public write access.
Web service currency converter