sending mail via QV

Wed, 21 Jan 2015 11:46:03 GMT

Hi,

Is it possible to send a mail,when the qvw file is reloaded?

Thanks in advance

Re: sending mail via QV

Anonymous — Wed, 21 Jan 2015 11:51:52 GMT

Hi,

Yes, it is possible.

In the main menu, go to Tools-Alerts and there you can set various options for sending an email/alert.

Hope this helps!

krishna20 — Wed, 21 Jan 2015 12:21:00 GMT

HI ,

Please find the below code in macros.It may helpful

Sub SendGMail()
' Object creation
Set objMsg = CreateObject("CDO.Message")
Set msgConf = CreateObject("CDO.Configuration")
' Server Configuration
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.gmail.com"
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 465
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "user@gmail.com"
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "password"
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = 1
msgConf.Fields.Update
' Email
objMsg.To = "user@gmail.com"
objMsg.From = "fromuser@domain.com"
objMsg.Subject = "Test send with Gmail account"
objMsg.HTMLBody = "HTML/Plain text message."
objMsg.Sender = "Mr. Name"
Set objMsg.Configuration = msgConf
' Send
objMsg.Send
' Clear
Set objMsg = nothing
Set msgConf = nothing
End Sub

Regards

Krishna

Tue, 08 Dec 2015 06:20:51 GMT

Helpful post!

alexantone — Tue, 08 Dec 2015 10:00:14 GMT

A very good altenative of sending alert /mail

However you must allowed scripting on Qlikview Server