topic Re: Sending email in QlikView

Sending email

Tue, 29 Nov 2011 20:30:39 GMT

Hi everybody.

I'm trying to send email from qlikview. I need to send a chart when the reload finished. I'm using the "after reload" trigger and a macro code found at this community. I'm exporting the chart to excel and after that attaching it. Now, I have two issues:

1) from the desktop edition, I can send only to recipients from the domain. The error I found is "550 5.7.1 Unable to relay for xxxxxx@xxxxx.com.ar "

2) is not working at all on the server. Even the files are not exported.

Hope someone can help.

Regards.

Damian

Sending email

Miguel_Angel_Baeyens — Tue, 29 Nov 2011 21:24:22 GMT

Hi Damian,

First, check your SMTP server settings, QlikView does nothing apart from telling the operating system to send a mail using CDOSYS or CDONTS likely (depending on the macro you are using). Contact your network and systems administators to test the mail sending from the server. You may need to aunthenticate in order to send emails through that server.

Second, OnLoad macros might not work in a client - server environment. There are some macro limitations as documented in the Reference Manual section 29.

Hope that helps.

Miguel

Sending email

Wed, 30 Nov 2011 14:24:43 GMT

Hi Miguel. What's the difference between CDOSYS and CDONTS? The macro I found use CreateObject("CDO.Message")

SMTP server settings were checked. In fact, mails from the server when a reload fails are sent.

I'm gonna check the macro limitations.

Thank you.

Damian.

Sending email

Miguel_Angel_Baeyens — Wed, 30 Nov 2011 18:33:45 GMT

Hi Damian,

Check this info document from Microsft detailing the differences between both. Basically, CDONTS is used on NT systems (Windows NT) and CDOSYS are used in higher versions of Windows Server (check here for further information on both). If you got the macro here in the QlikCommunity, it's likely CDOSYS and should work just fine in your computer.

Hope that helps.

Miguel

Sending email

Thu, 01 Dec 2011 15:29:37 GMT

Hi Miguel.

So, there is another way to do that?

Regards.

Damian

Re: Sending email

Thu, 01 Dec 2011 16:58:31 GMT

I think I've found the way: installing the desktop edition on the server and using /r option from command line

But now, after the reload from command line, the exported file is generated, but the mail is not sent. If I open the qvw with the desktop and made a reload, it works fine. Do you know why?

Regards.

Damian

Sending email

Miguel_Angel_Baeyens — Thu, 01 Dec 2011 19:46:00 GMT

Hi Damian,

First of all, and pretty obvious, but have you checked the Server SMTP mail configuration in the QlikView Enterprise Management Console and let QlikView know where to send the mail through? Go to the QEMC, System, Setup, Mail Server. Use that same page to send a test mail.

Hope that helps.

Miguel

Sending email

Thu, 01 Dec 2011 19:59:23 GMT

These settings are correct, I received the test mail.

Regards.

Damian

Sending email

Miguel_Angel_Baeyens — Thu, 01 Dec 2011 20:06:38 GMT

Hi,

Then your email should be sent just fine. Can you share the macro code that you are using (with user names and password removed) so we can see what's going wrong?

Did you try code from this thread?

Hope that helps.

Miguel

Re: Sending email

Thu, 01 Dec 2011 20:31:07 GMT

Yes, I try that trhead. Attached is my code. Than you.

Regards.

Damian

Re: Sending email

Wed, 14 Dec 2011 20:38:18 GMT

Hi Miguel, I want to ask you something else. I made some changes to the code. The macro is on the OnPostReload trigger. I added a log routine. I'm sending emails from QV desktop (installed on the server), and the log file is OK. But, from command line with /r option the execution is aborted, without errors. And the log file is not created. Attached is my code.

My suspect is that the problem is the Module Security Level and User Allowed Security Level. When I opened the document with the desktop, I answer to let macros. But from command line there is no question like that.

Can you help me?

Re: Sending email

Anonymous — Wed, 14 Dec 2011 20:48:01 GMT

When I configure my mail server settings and send a test email, I get the following: "Email was sent successfully, please check your inbox." When I check my inbox there is no email.

Am I missing something?

Re: Sending email

Miguel_Angel_Baeyens — Thu, 15 Dec 2011 13:38:53 GMT

Hi Damian,

Use the /NoSecurity parameter in addition to the /r so you are not prompted for macro security or it stops when it cannot prompt:

"C:\Program Files\QlikView\qv.exe" /NoSecurity /r "C:\File.qvw"

Hope that helps.

Miguel

Re: Sending email

Miguel_Angel_Baeyens — Thu, 15 Dec 2011 13:39:44 GMT

Hi Cori,

Is there any chance that your emails are dropping into the spam or junk folder instead of the inbox?

Regards.

Miguel

Re: Sending email

Anonymous — Thu, 15 Dec 2011 14:19:07 GMT

Migueal, that is what it was. Thanks for the post.

Re: Sending email

Thu, 15 Dec 2011 14:40:04 GMT

Hi Miguel.

I added /NoSecurity in the command line. Still the same problem... the log file is created, but empty. The mail is not sent. Something else I can do?

Thanks. Regards.

Damian.

Re: Sending email

Anonymous — Thu, 15 Dec 2011 14:40:36 GMT

Migueal,

Thats what it was, thanks for the post.

Cori