sending Mail

[#1]

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

[sushil353]

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

[Anonymous]

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

[sushil353]

Hi,,,

Can you provide the code for macro..

HTH.

[gandalfgray]

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

[Anonymous]

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