Can multiple rows be included in a "mailto:" link?

building reports webintelligence
1

I would like to create an email hyperlink that sends information related to the recipient in the body of the email. Each recipient has one email address, but may have multiple lines of data associated with them. The “mailto:” hyperlink will only read one row at a time:

="<a href=“mailto:”+ [Advisor Email Addresses INT 1] + " ?body=" + [Students Id] +[First Name] + [Last Name] + [Sutdent Email Addresses IN2] + "&Subject=Message%20about%20Your%20Advisee(s) "> “+ [Advisor Email Addresses INT 1]+” "

I have tried setting the email hyperlink as a section, but that just creates a multi-value error. Is it possible to pull multiple rows into an email hyperlink by this or any other method, or is this simply not possible?

Thanks for any help/tips/advice you may be willing to offer.

hbailey (BOB member since 2015-08-13)

2

You could probably do values from the next Row using the Previous Next functions, but I`m guessing you have a in determinant number of proceeding rows that might want including in the email. not sure it can be done in Webi, could probably done in Crystal though.

ABILtd :uk: (BOB member since 2006-02-08)