Send Mail from QlikView with table in the mail body

[Alex78]

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

[bharathadde]

Try this

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

Hope this works for you

[Alex78]

Thank you Bharathadde. This is not working for me. 

[bharathadde]

it worked for me, please find below attachment.

[Alex78]

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

[bharathadde]

if possible can you please attach qvw file

[Alex78]

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

[bharathadde · Accepted solution]

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.

[Alex78]

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!!