Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Im Not Having QlikView Publisher, How Can I send The Reports On a Scheduled Basis
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
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
Hi,,,
Can you provide the code for macro..
HTH.
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
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