topic Re: Send mail from document in QlikView

Send mail from document

gidon500 — Thu, 27 Nov 2014 08:04:40 GMT

Hi guys

Is it possible to send selected data from an object

by email

if yes , how can i do it ?

thanks

gidon

Re: Send mail from document

datanibbler — Thu, 27 Nov 2014 08:14:52 GMT

Hi gidon,

it's possible to send an email from an object - I was given a hint here in the Community.

You can attach some data from QlikView, too.

Here's how my "Feedback button" looks - I have that on every sheet in every app.

There's a trigger which opens a URL which reads like

>>> = 'mailto:[email_address]?subject=Feedback_QlikView' & '; ' & Subfield(DocumentName(), '.qvw', 1) & '; ' & Subfield(GetActiveSheetId(), '\', 2) <<<

=> I get an email with the subject "Feedback QlikView" and with the info which app the email was sent from and which sheet - as there is only one KPI_display per sheet, I know immediately which KPI the email is about.

HTH

Best regards,

DataNibbler

Re: Send mail from document

daveamz — Thu, 27 Nov 2014 09:39:04 GMT

Hi Gidon,

If you just want to send a object from QlikView see this post: http://community.qlik.com/docs/DOC-3549

Regards,

David

Re: Send mail from document

gidon500 — Thu, 27 Nov 2014 10:58:48 GMT

Hi Daniel

Thaks for your prompt relay ,

can you send me qlik document with the example

thanks

gidon

Re: Send mail from document

Anonymous — Thu, 27 Nov 2014 11:39:36 GMT

Hi David

If you want to send mail from outlook below is the code

sub Test

Set myApp = CreateObject ("Outlook.Application")

Set myMessage = myApp.CreateItem(olMailItem)

Mon="January"

username_temp= myApp.GetNameSpace("MAPI").CurrentUser

UserName_from= left(username_temp,len(username_temp)-9)

msg= "your message...."

myMessage.BodyFormat = 3

myMessage.To = InputBox("Enter email address in johnsmith@mail.com format","Email Address")

myMessage.Subject = Subject "

'myMessage.body="Hiiiiiiiiiiiiiiiiiiii"

myMessage.HTMLBody = _

msg

myMessage.Attachments.Add "C:\temp\DimensionMme.xlsx"

myMessage.Attachments.Add "C:\temp\sqldeveloper\icon.png"

myMessage.Attachments.Add "R:\community\EmailMacro[1].qvw"

myMessage.Send

msgbox("Mail Send")

Set myMessage = Nothing

Set myApp = Nothing

end sub

' Sub routine that runs when you click CommandButton1.

Sub username()

Set myApp = CreateObject ("Outlook.Application")

Set myMessage = myApp.CreateItem(olMailItem)

' Message box that returns the current user's name.

Msg = myApp.GetNameSpace("MAPI").CurrentUser

msgbox left(msg,len(msg)-9)

End Sub

regards

Harsha

Re: Send mail from document

Anonymous — Thu, 27 Nov 2014 11:45:54 GMT

or try this attached app

Re: Send mail from document

gidon500 — Thu, 27 Nov 2014 15:24:50 GMT

Hello

i have tried this made some chages and it works fine

i need some more help

the data i want to sent is to different sales agent

the email address is available in the document .

when i select an agent ,

I want to push the bottom SENDMAIL ,

and it will take the email address from the agent table

can you help

thanks

gidon