Categories
How to add Hyperlink in SQL for Bursting in BI Publisher
Hello,
I would like to ask if someone from you encounter of adding a hyperlink in the message body for bursting in BI Publisher.
Delivery Channel is Email with the following Parameter values:
PARAMETER1: Email Address
PARAMETER2: cc
PARAMATER3: From
PARAMETER4: Subject
PARAMETER5: Message body - this contains the text with the hyperlink, e.g. HR Transactions (which has hyperlink pointing to a mail address: 12345@xyz.com)
Any help is much appreciated.
Best Regards,
Eli
Answers
-
I know this is very old - but ill put my comment in as I was recently searching for the same. You have write paramter5 in HTML- so something like this:
' <html> Hello sir, <br/><br/>
More Email Body message test here. <br/><br/>
LINK BELOW:
<a href="www.google.com" >LINK DISPLAY TEXT</a> <br/><br/>
Sincerely,<br/><br/>
Bob <br/><br/> </html> ' PARAMETER 5,
So the above will give you an email that looks like this where "LINK DISPLAY TEXT" if clicked will link to the hyperlink defined (www.google.com in our example)
Hello Sir,
More Email Body message test here.
LINK DISPLAY TEXT
Sincerely,
Bob
1 -
0
