If you are unable to create a new account, please email support@bspsoftware.com

 

Link Lotus Notes email ids to a Cognos query item in a report

Started by XcognosX, 08 May 2014 09:12:21 AM

Previous topic - Next topic

XcognosX

We have a requirement that we need to click on a person's name in a Cognos report and then land on Lotus Notes email page that addressed to that particular user

Exact requirement is,

We have a list report that has employee names and sales amounts.
When a user clicks on a employee name, a lotus notes email should get opened

This is pretty similar to what we see in most websites. Users click on 'Contact us' link and it will automatically open a
your default email with receiver's email adress

Has anyone done this ? I appreciate any feedback

Thank you in advance 

MFGF

Hi,

You can do this by adding a query calculation that takes the user's email address and prefixes it with 'mailto:'

Then add a Hyperlink object (from the toolbox) to your list as a new column. In the properties of the column, set the Source Type (under Text Source) to be Data Item Value and in the Data Item Value property directly underneath, select the calculated item. Make the exact same change to the Source Type and Data Item Value properties under URL Source.

Assuming Notes is the user's default email client, this will then result in a new message to the specified email address being spawned in Notes.

Cheers!

MF.
Meep!