As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
Anyone using Activesend to pass email address variables from webfocus report to OWA?
We have a report that lists an agents name and when the user clicks the name it brings up a blank email message and populates the email address and subject line with variables passed from the HTML page. It was working fine with XP and the old version of Activesend but now that we have moved to Win7 and Activesend 8.1.0 it has stopped working.
This works fine with regular Outlook but unfortunately we cannot provide Outlook to all our outside users.
Any help would be greatly appreciated. I am working with Messageware but they have yet to reply with any help.
Thanks JVThis message has been edited. Last edited by: <Kathryn Henning>,
Have you heard back from Messageware about this? I wasn't able to locate any information either internally or on the Web about this.
You mentioned that after moving to a different OS and version of Activesend, it stopped working. Does the blank email message come up at all, or does it come up and then fail to populate?
Would you happen to have any documentation on the old version of Activesend where it describes how they're reading the variables being passed in to populate the email address and subject?
Sorry and the version we are using now is 10.5.4. My laptop has not been updated. We also went to Exchange 2013 which may also have something to do with it.
This code is built for a stored procedure that is passed to us. See javascript in style code below.
-SET &ECHO=ALL;
SET EMPTYREPORT = ON
SET ALL = PASS
SET NODATA='';
-INCLUDE routines/setmssparms.fex
-INCLUDE routines/extract_session_tscomid.fex
APP HOLD &SYSAPATH
-*SET &PolicyNumber = &txtPolNum;
-TYPE &PolicyNumber
SQL SQLMSS SET SERVER &MSSSPTAB1;
SQL SQLMSS EX [dbo].[rptCurrentQueuebyPolicyNumber] '&PolicyNumber';
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS &TSCOMID FORMAT ALPHA
END
DEFINE FILE &TSCOMID
TOT/I10=IF DocType EQ LAST DocType THEN 1 ELSE 1;
NEW_EMAIL/A50=IF EmailAddress EQ ' ' THEN 'N/A' ELSE EmailAddress;
NEW_DOCTP_DESC/A500='Policy '| PolicyNumber ||(', Insured Name: '| InsuredName);
END
TABLE FILE &TSCOMID
PRINT PolicyNumber
ProcessName
ProcessID
TakenBy
AssignedTo
StepDescription
Category
DocType
DaysInQueue
NEW_EMAIL NOPRINT
NEW_DOCTP_DESC NOPRINT
-*NEW_FULLNAME
TOT NOPRINT
-*WHERE PolicyNumber EQ '&PolicyNumber';
ON TABLE SUBHEAD
"Current Queue by Policy Number"
ON TABLE SUBFOOT
"Generated on &DATEMDYY"
"Total Number of Jobs <TOT.TOT"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=DATA,
COLUMN=N9,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N5,
WHEN=N7 NE 'N/A',
JAVASCRIPT=fnMail(NEW_EMAIL NEW_DOCTP_DESC),
$
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN
<SCRIPT LANGUAGE=JAVASCRIPT>
function fnMail(Email,Subject)
{
window.location = 'mailto: ' + Email + '?Subject=' + Subject;
}
</SCRIPT>
-IF &LINES NE 0 THEN GOTO ENDING;
-HTMLFORM BEGIN
<br>
<font face="arial,helvetica,sans-serif">No records found.</font><br></font>
-HTMLFORM END
-ENDING