Home Forums Reporting Services Reporting Services SSRS 2008 Report - Hyperlink on Name - After Clicking - Open Outlook Mail with Subject and Body RE: SSRS 2008 Report - Hyperlink on Name - After Clicking - Open Outlook Mail with Subject and Body

  • I'm using this, its great and works! But is there any way to list all 5 records that exist for this dataset instead of FIRST or LAST? This is a report that will run 1x per week, so there can be multiple records for each user and I'd like to like them in the email. The txt.1 field will have mulitple occurrences.

    ="MailTo:me@wn.com" & "?Subject=My Held Time " & "&Body=Hello Team, " & VBCRLF & VBCRLF & "SKU: "& First(Fields!employee_code.Value, "TmHeldEmail") & VBCRLF & "Country: " & first(Fields!txt1.Value, "TmHeldEmail")

    Thank you for your help,

    Mary