topic sending Mail in QlikView

sending Mail

Fri, 19 Aug 2011 05:52:05 GMT

Im Not Having QlikView Publisher, How Can I send The Reports On a Scheduled Basis

sending Mail

sushil353 — Fri, 19 Aug 2011 06:35:45 GMT

Hi.....

you can create batch file for the above requirement... If you have server access then chekout the server logs and you can send the file through mail using batch file...

HTH

Sushil

sending Mail

Anonymous — Fri, 19 Aug 2011 06:49:29 GMT

Hi sandeep,

You can send mail thru macros . attach report as XL/pdf/ppt.

once macro part is ready, you can Schedule it on the scheduler tab (settings-> Document properties->scheduler)

and in triggers tab select on postreload click on edit action select

add action -> external and in action select Run macro

macro name add the macro name.

Currently using Ver 10.0 SR1

sending Mail

sushil353 — Fri, 19 Aug 2011 06:52:38 GMT

Hi,,,

Can you provide the code for macro..

HTH.

sending Mail

gandalfgray — Fri, 19 Aug 2011 06:57:57 GMT

You can send mails directly from the qvw using macro code (VBscript).

For syntax etc, see http://www.w3schools.com/asp/asp_send_email.asp

sending Mail

Anonymous — Fri, 19 Aug 2011 07:06:28 GMT

Hi , got this code from http://social.technet.microsoft.com/Forums/en/ITCG/thread/62bdd4e5-2957-4258-a0fc-cd821ee33860

Set objEmail = CreateObject("CDO.Message")

objEmail.From = "<e-mail address>"

objEmail.To = "<e-mail address>"

objEmail.Subject = "TEST E-Mail Script" & vbTab & Now()

objEmail.Textbody = "TEST E-Mail Script" & vbTab & Now()

objEmail.AddAttachment "C:\ZZZ.Zip"

objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2

objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.comcast.net"

objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25

objEmail.Configuration.Fields.Update

objEmail.Send

Wscript.Echo "DONE"

Wscript.Quit

test this code , modify the bold font ie smtpserver and port number.

hope this will help you