How do I hotlink email addresses in reporting services?

Question

I have a dataset that returns with individuals email addresses. I would like the ability to just click on them and boom up pops a message addressed to that person just like in any other MS application.

I tried right-clicking the field, go to properties, then the action tab, and point the "go to url" to the email column list in the data set and no go.

This seems like a no brainer...

Answer 1

It has to be a valid URL link, not just an email address, so you have to prepend it with "mailto:". For example, make the navigation URL be an expression like:

="mailto:" & Fields!EmailAddress.Value

For bonus points, add a subject:

="mailto:" & Fields!EmailAddress.Value & "?subject=This report is great!"

Or even a subject and a body:

="mailto:" & Fields!EmailAddress.Value & "?subject=This report is great!&body=You deserve a raise!"

Of course, the expression for the Value property of the cell should remain just as the email address.

Answer 2

="MailTo:" + Fields!EMAIL.Value & "?Subject=" + Fields!SUBJECT.Value