June 6, 2012 at 3:25 pm
What is the correct syntax to use with the <Action><Jump to URL> to open a new email message ?
I've tried:
mailto:EmpEmail.value?subject=ReportInfo.value
(where EmpEmail is the email address and ReportInfo is the name of a report.)
This will open the new message, but doesn't pull the coreect values.
Thanks much.
Beth L
June 7, 2012 at 8:50 am
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
June 7, 2012 at 8:58 am
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 ?
June 7, 2012 at 1:13 pm
I finally got this to work using this syntax:
="mailto:" + Fields!EmpEmail.Value+"?"+ "Subject=" +First(Fields!ReportInfo.Value, "ReportInformation")
June 8, 2012 at 3:39 am
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
June 20, 2012 at 7:34 am
Thank you for the comments - I will test & adjust as needed.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply