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

Send Mail from QlikView with table in the mail body

Alex78 — Sat, 16 Nov 2024 04:23:58 GMT

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

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

bharathadde — Tue, 19 Feb 2019 21:24:18 GMT

Try this

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

Hope this works for you

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

Alex78 — Fri, 22 Feb 2019 14:50:13 GMT

Thank you Bharathadde. This is not working for me.

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

bharathadde — Fri, 22 Feb 2019 16:41:08 GMT

it worked for me, please find below attachment.

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

Alex78 — Fri, 22 Feb 2019 19:33:23 GMT

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

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

bharathadde — Fri, 22 Feb 2019 19:38:16 GMT

if possible can you please attach qvw file

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

Alex78 — Fri, 22 Feb 2019 20:40:21 GMT

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

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

bharathadde — Fri, 22 Feb 2019 21:06:13 GMT

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.

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

Alex78 — Fri, 22 Feb 2019 21:45:55 GMT

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