Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Send Mail from QlikView with table in the mail body

HI all,

I have a table chart with few columns. I would like to send email from each row (based on users selection). When clicking on the table row outlook will fire up and the From: , To:, Subject:, and Email Body:, populated from fields in the qvw. 

So far I used the following:

Send Email ' & '<url>mailto:' & email_column & '?subject= Subject_column in the expression and used "Link" as Representation.

This gives me the  the To:, From:, and Subject: lines on Outlook. 

How can I add the body content? For example, I would like to see the email as:

From: Sender@domain.com

To: Receiver@domain.com

Subject: Subject Line

Dear Receiver,  ....

School Name = School_Name   (School_Name will be from the data model related to the receiver)

Assignment Group  = Assignment_Title  (Assignment_Title  will be from the data model)

End.

 

Thank you in advance

A

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

Re: Send Mail from QlikView with table in the mail body

Here you go, I fixed it and attached qvw to this message

Expression is like below

='Send Grade' & '<url>mailto:' & EmailAddress & '?subject= ' & 'Your Grade' & '&body=' & 'Dear ' & [StudentName] & ' , your grade for the course ' & Course & ' is ' & Grade & '.' &
chr(10) & ' Should you need to have any clarification, please consult your teacher ' & Teacher & chr(10) & 'Thank you'

I tried using chr(10) for enter but it didn't work, you can try some other chr for it.

View solution in original post

8 Replies
Highlighted
Creator II
Creator II

Re: Send Mail from QlikView with table in the mail body

Try this

Send Email ' & '<url>mailto:email_column?subject=Subject_column&body=body_column

Hope this works for you

Highlighted
Contributor III
Contributor III

Re: Send Mail from QlikView with table in the mail body

Thank you Bharathadde. This is not working for me. 

Highlighted
Creator II
Creator II

Re: Send Mail from QlikView with table in the mail body

it worked for me, please find below attachment.

Highlighted
Contributor III
Contributor III

Re: Send Mail from QlikView with table in the mail body

When using actions in the text box, it works. What I would like is to send from a table chart. I have a table and each row is going to have a link. It is on clicking this row value that the email should fire with To, cc, Subject and email body.

Thank you again

A

 

Highlighted
Creator II
Creator II

Re: Send Mail from QlikView with table in the mail body

if possible can you please attach qvw file

Highlighted
Contributor III
Contributor III

Re: Send Mail from QlikView with table in the mail body

I have attached a simple qvw with inline data. The "Send Email to" column is the link that need to send email with the content like what is described in the text box in the sheet. The email body will have values from the inline table fields.

 

Thank you

A

Highlighted
Creator II
Creator II

Re: Send Mail from QlikView with table in the mail body

Here you go, I fixed it and attached qvw to this message

Expression is like below

='Send Grade' & '<url>mailto:' & EmailAddress & '?subject= ' & 'Your Grade' & '&body=' & 'Dear ' & [StudentName] & ' , your grade for the course ' & Course & ' is ' & Grade & '.' &
chr(10) & ' Should you need to have any clarification, please consult your teacher ' & Teacher & chr(10) & 'Thank you'

I tried using chr(10) for enter but it didn't work, you can try some other chr for it.

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Send Mail from QlikView with table in the mail body

Yes. It works. For new line I updated it like the following:

='Send Grade' & '<url>mailto:' & EmailAddress & '?subject= ' & 'Your Grade' & '&body=' & 'Dear ' & [StudentName] & ' , your grade for the course ' & Course & ' is ' & Grade & '.' &
'%0A %0A' & ' Should you need to have any clarification, please consult your teacher ' & Teacher & '%0A %0A '& 'Thank you'

 

Thank you!!