Hyperlink to Email Address

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113528 More actions · Answer 1

where do empemail and reportinfo come from? do you have a dataset with them in or are they parameters?

mailto:Parameters!EmpEmail.Value?subject=Parameters!ReportInfo.Value

mailto:Fields!EmpEmail.Value?subject=Fields!ReportInfo.Value

budbeth Say Hey Kid Points: 694 More actions · Answer 2

Thanks for the response - -

EmpEmail comes from the dataset the table is based on.

ReportInfo comes from another dataset set used in the report.

I tried your suggestion of:

mailto:Fields!EmpEmail.Value?subject=Fields!ReportInfo.Value

That puts empemail.value in the To: field and ReportInfo.Value in the Subject: field.

It doesn't return the values of these fields, just the field names.

In Excel I use =HYPERLINK("mailto:"& C11 & "?Subject=" & B3, A11) which works.

Any other suggestions ?

budbeth Say Hey Kid Points: 694 More actions · Answer 3

I finally got this to work using this syntax:

="mailto:" + Fields!EmpEmail.Value+"?"+ "Subject=" +First(Fields!ReportInfo.Value, "ReportInformation")

Micha-1016108 SSC Journeyman Points: 83 More actions · Answer 4

We are using hyperlinks "mailto:" in nearly all of our reports.

Use "&" instead of "+" to concatinate strings.

="mailto:" & Fields!EmpEmail.Value+"?" & "Subject=" & First(Fields!ReportInfo.Value, "ReportInformation")

Be aware if EmpEmail contains several email-Adresses it will not work for all mail clients.

Be aware if ReportInfo constains specifique characters like "%, &, ..." it will also fail.

We have developed some VB-Code to convert data into a correct mailto:hyperlink

budbeth Say Hey Kid Points: 694 More actions · Answer 5

Thank you for the comments - I will test & adjust as needed.

Cookies on SQLServerCentral