How to add Hyperlink in SQL for Bursting in BI Publisher

Question

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

Mallikarjuna Kuppauru-Oracle · Answer

Hi @Marko Puskac

Thanks for sharing your inputs on this thread.

Regards,

Arjun

Marko Puskac · Answer

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: ' Hello sir,

More Email Body message test here.

LINK BELOW: LINK DISPLAY TEXT

Sincerely,

Bob

' 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