Hyperlink email address in report

(2 posts) (2 voices)

Tags:

No tags yet.

  1. xstrom, Member

    I have a report that produces a corresponding email address to each customer account. Is it possible to hyperlink only the email addresses in the report so when you click it the default email client opens with the email address populated in the "To:" field?

    Thanks!!

  2. myDBR Team, Key Master

    You can use the 'dbr.purehtml:'-prefix for text that will allow html code to be passed into the report. Use the standard mailto-link (http://en.wikipedia.org/wiki/Mailto) to achieve this:

    select concat( 'dbr.purehtml:< a href="mailto:', email, '">', name, '< /a>')
    from mytable;

    (remove the extra spaces the forum sw requires)

    --
    myDBR Team


Reply

You must log in to post.