ajc101
ajc101

Reputation: 49

SSRS MailTo Expression

I have a textbox with the following expression- ="MailTo:[email protected]".

I have tried with and without the quotes. With the quotes, I just get the actual text, which is MailTo:[email protected]. Without the quotes, I receive an error about using a colon.

What I want to do is hyperlink the email address so that it can be clicked on in the report, and have outlook open. How can I achieve this?

Apparently, the above does not describe my problem enough...let's see if this works...

Upvotes: 1

Views: 4768

Answers (1)

alejandro zuleta
alejandro zuleta

Reputation: 14108

Right click the textbox and go to Textbox properties, in the Action tab select Go to URL and use the expression you need:

 ="mailTo:[email protected]"

Also if you set the Place Holder Markup Type property to HTML you can use an expression like this:

="<a href=" & CHR(34) & 
"mailto:[email protected]" & Chr(34) &
">send mail to alejandro</a>"

Which results in a hyperlink to the specified mail address that executes your default E-Mail client to send the mail.

Let me know if this helps.

Upvotes: 2

Related Questions