Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
bradlocke
Contributor III
Contributor III

Using Email Link in a Table

Hello. Need some assistance if what I am asking is possible...

I have a straight table that contains the following columns in order:

  1. Reference Number
  2. Certificate
  3. Date
  4. County
  5. Zip Code
  6. Contact Name
  7. Contact Email
  8. Contact Phone

There are hundreds of rows that all have the same type of data. The email column is where I have my question. It is formatted as a link (representation format) so the user can click it and it opens the user's default email program and inserts the email address.

Is there a way to write the expression so that it also inserts the corresponding reference number in that row, from column one, in the email in either the subject line or body text?

Thanks in advance.

Labels (2)
1 Solution

Accepted Solutions
neerajthakur
Creator III
Creator III

Add this as link, you can also add cc and bcc and adding &bcc=<emailid> and &cc=<emailid>

For Using it in body use : &body="Reference Number"

'mailto:'&"Contact Email"&'\?subject='&"Reference  Number"&'&body='&"Reference Number"

 

Sample : mailto:xyz@gmail.com?cc=abc@gmail.com&bcc=123@gmail.com&subject=Subject Line&body=BODY

Thanks & Regards,
Please Accepts as Solution if it solves your query.

View solution in original post

5 Replies
neerajthakur
Creator III
Creator III

Add this as link, you can also add cc and bcc and adding &bcc=<emailid> and &cc=<emailid>

For Using it in body use : &body="Reference Number"

'mailto:'&"Contact Email"&'\?subject='&"Reference  Number"&'&body='&"Reference Number"

 

Sample : mailto:xyz@gmail.com?cc=abc@gmail.com&bcc=123@gmail.com&subject=Subject Line&body=BODY

Thanks & Regards,
Please Accepts as Solution if it solves your query.
bradlocke
Contributor III
Contributor III
Author

magnifique! Thank you!

Theshantanu
Contributor
Contributor

Thanks .. I had a similar question, this helped!!

AmirTaub
Contributor II
Contributor II

how can i make the link to open OUTLOOK (desktop) 
i am using sense (not cloud)

neerajthakur
Creator III
Creator III

Make outlook as your default mail app.

  1. In Windows, select Start and type Default apps.
  2. Select Default apps from the suggestions.
  3. Under Email, if Outlook is not listed, select the app that is listed to be presented with a list of email apps installed on your computer, then select Outlook.
Thanks & Regards,
Please Accepts as Solution if it solves your query.