Home› General
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

emailing report from a service app

rbuserrbuser
edited June 2009 in General
Hello,

I have a service app that I seem to be having an issue getting the report to
email. I'm trying to automate reports used in our application.

When Using Indy10 My firewall states an SMTP connection is made to our ISP's
email server but I never get the email. I contacted our ISP and they state
they never see the email come in. For testing purposes I switched the
emailing to to MAPI but when I do that I get an error that states Login
Failure. I haven't been able to locate the issue. I have been through all
of the demos and it appears I have put in all the missing parts. If I use
the Demo application everything works properly. Is there something I have
to do since my report is being generated from a service?

Thanks in advance,
Rodger Van Kirk

Comments

  • nicociziknicocizik
    edited June 2009
    Hi Rodger,

    Take a look at the following article on detecting email errors. Perhaps
    this will give us some clues on what is happening when Indy is run through a
    service app.

    http://www.digital-metaphors.com:8080/Output/Email/How_To...Show_Email_Errors

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • rbuserrbuser
    edited June 2009
    Hello Nico,

    I do have that in place. When sending through Indy the event never
    triggers. When sending through MAPI that is when I get the "Login Failure"
    error.

    Rodger Van Kirk


  • nicociziknicocizik
    edited June 2009
    The MAPI plugin uses Simple MAPI which does not support service
    applications.

    The Indy plugin simply creates a TidSMTP object and sends the email. Are
    you able to successfully send an email via Indy with the demo as well as
    MAPI? Perhaps try tracing into the ppSMTPIndy10.pas file specifically the
    Connect and SendMail routines and see if you can find where the problem is
    occuring.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • rbuserrbuser
    edited June 2009
    Nico,

    I'm still waiting on an update to ReportDevices so I can't debug with the RB
    source code yet.

    With all my tweaking with the code today I am all of a sudden getting an
    Adobe window that is opening with the following error. "There was an error
    opening this document. This file can not be found." I'm not sure if this
    is relevant. I guess I would also now wonder what I did that was causing
    the adobe viewer to open so I can stop it.

    Rodger Van Kirk


  • rbuserrbuser
    edited June 2009
    Nico,

    I thought it was Report.EmailSettings.DeleteFile := False

    I changed it back to to true now I get the Adobe window and it shows the
    report. But the email still does not get sent.

    Rodger Van Kirk


  • rbuserrbuser
    edited June 2009
    Correction.

    I meant to say ExportDevices not ReportDevices.


  • rbuserrbuser
    edited June 2009
    I found the issue with the adobe window opening. The adobe window open if I
    run the service from the IDE. If I run the service normally no adobe window
    opens. The file not found error I believe is caused by setting
    EmailSettings.DeleteFile to True. But still doesn't help with the emails
    not being sent.

    Rodger Van Kirk


  • rbuserrbuser
    edited June 2009
    Nico,

    I think I found the problem. I need to include a username and password even
    though I do not have to set outlook to authenticate.

    Rodger Van Kirk

This discussion has been closed.