Using Email Link in a Table

[bradlocke]

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.

[neerajthakur · Accepted solution]

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

[bradlocke]

magnifique! Thank you!

[Theshantanu]

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

[AmirTaub]

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

[neerajthakur]

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.