Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro to send email via Ajax Client

I'm using the below to send an email that is launched from an action on a button.  It works fine using the plugin client but nothing happens when using the ajax client.  Does anybody know how to get this macro to work in ajax or another way to do the same task using the ajax client.

Nprinting or paid third party software is not an option.

function sendemailBySMTP

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") = "mail.company.com"

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

msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 0

msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "qlikservice.gen@cisco.com"

msgConf.Fields.Update

objMsg.To = "johfegan@company.com;srickman@company.com"

objMsg.From =  "gen@company.com"

objMsg.Subject = "\\servername\G\Temp"

objMsg.TextBody = "Please retrieve your file at the above location. Your file will be deleted in 3 hrs"

objMsg.Sender = "qlikservice.gen@company.com"

Set objMsg.Configuration = msgConf

' Send

objMsg.Send

      

END function

3 Replies
marcus_sommer

Such a macro isn't possible within the AJAX-client because it used ActiveX-functionalities (btw. the most macros won't work in AJAX). But you could create a concatenated link within a table-chart or a textbox which opens your default mail-client and which you only need to send, see as example:

mailto: YourRecipients@xxx.com?subject=Betreff&body=file://\\YourServer\d$\Master.html&attachment=\\YourServer\d$\Master.html

Also helpful might be: Re: Opening Mails in Qlikview

- Marcus

Not applicable
Author

So I would essentially open a browser and have the user send an email to themselves.

marcus_sommer

I believe there is no (real) other way - a document extension might make it easier and/or bring more features and flexibility but I doubt that already one exists.

- Marcus